468,746 Members | 1,854 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,746 developers. It's quick & easy.

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
help.
Set RsRepSummary = db.OpenRecordset("SELECT * FROM
tblSummary ORDER BY tblSummary.Regid DESC", dbOpenDynaset, dbReadOnly)

Set WS = Worksheets.Add

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

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.