471,070 Members | 1,368 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,070 software developers and data experts.

Please help with hyperlinking rows in summary worksheet

Hi Folks
I am trying to hyperlink values in B column to the matching worksheets
(Names) using the following routines which is not working, the
RsRepSummary record set writes values to B column starting from B2 and
there are already matching worksheet names in the same workbook, how
can I refer to values in cells of B column - thanks much for your
Set RsRepSummary = db.OpenRecordset("SELECT * FROM
tblSummary ORDER BY tblSummary.Regid DESC", dbOpenDynaset, dbReadOnly)

Set WS = Worksheets.Add

WS.Name = "Summary"
WS.Tab.ColorIndex = 15
fCount = summRows + 1
summRows =
For j = fCount To fCount + summRows - 1
Range("B" & j).Select
WS.Hyperlinks.Add Anchor:=Selection,
Address:="", SubAddress:= _
"'" & B & j & "'!A1", TextToDisplay:=B & j
Nov 12 '05 #1
0 1192

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chris Plowman | last post: by
reply views Thread by sunilkumar Reddy via DotNetMonster.com | last post: by
5 posts views Thread by Anand | last post: by
1 post views Thread by =?Utf-8?B?VGVycmFuY2U=?= | last post: by
4 posts views Thread by =?Utf-8?B?Y29uc3RhbnRpbg==?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.