By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,844 Members | 1,499 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,844 IT Pros & Developers. It's quick & easy.

Please help with hyperlinking rows in summary worksheet

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.