I obviously missed the boat on this one - and I'm curious, is this
different, or better than, Application.Goto?

Thanks,

Doug

"Dick Kusleika" wrote in message
...
James

ThisWorkbook.FollowHyperlink "#Sheet1!A3"

Not very intuitive, but that's what works.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


James Cox wrote:
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