If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Vba Hyperlink To Local Worksheet

I would like to, using VBA, assign a hyperlink to an excel cell that links to another worksheet within the same workbook. I've tried the forums, and combined with a previous post and MS Excel Help File, I've come up with the following attempt:

My spreadsheet file is "WeatherTester.xls", my worksheet is "1", and "A1" is the desired link location for the cursor.

Counter is an integer.

I get the error "Invalid procedure call or argument"

I also tried to enter a hyperlink directly through the formula property, but Excel didn't like the single quotations I had to use within the HYPERLINK function. The hyperlink formula works in the following form:

Re: Vba Hyperlink To Local Worksheet

Thanks for the help. The subaddress thing definitely worked, although I can't quite get the text display deal to work. Basically each iteration through the loop represents a day after 1 Jan 2007, so I'm trying to get the display date to increment with the hyperlink. The date as stated with the string & counter creates hyperlinks that look like: 1/1/20071. It seems like it should be easy, but its not working the way I think it should.

Re: Vba Hyperlink To Local Worksheet

If you care, I fixed the "TextToDisplay" problem... I just declared a string variable and set it equal to the desired date. I used that variable as the argument and excel liked it better. Thanks again.