Doug -

Well, that adds a hyperlink to the workbook at the location of the current
cell - which I need to avoid because it could overwrite whatever was in the
current cell when the macro runs.

Also, it doesn't go to the hyperlink target - just creates the hyperlink and
stays there.

Thanks for the help, but that's not the functionality needed....

James



"Doug Glancy" wrote in message
...
James,

Running the macro recorder, I get this, which adds the Anchor parameter to
what you've got. Does that help?

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A1", TextToDisplay:="Sheet2!A1"

Doug

"James Cox" wrote in message
...
I can get the following to work in a VBA sub:

ThisWorkbook.FollowHyperlink Address:="http://example.microsoft.com"

but get an error when I try to specify a location in the workbook with:

ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3"

It seemed that would be the proper format for the address in the open
workbook, but I'm picking up an error - "Run time error 5 - Invalid
procedure call or argument"

What am I missing or doing wrong here? I really need to do this
programatically and not have to define a "fixed" hyperlink on the
worksheet
(or anywhere else).

Thanks in advance for any help you can give!

James