Con Tang
ActiveSheet.Hyperlinks.Add .Range("E" & RowNdx),
Address:=.Range("E" & RowNdx),
TextToDisplay:="http://www.mysite.com/WebReports/test_html.asp?ID="
Range("B" & RowNdx).Value
Change the Address part to this
Address:=.Range("E" & RowNdx).Address,
You will telling the hyperlink to point to the range that it sits in - which
means it does nothing at all. By omitting the .Address property, it is
assuming you want the .Value property (.Value is the default property of the
Range object.) See if adding the Address property takes care of it.
--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com