creating hyperlink excel 2003 vba

S

sweet_dreams

Hi all,

I was trying to create hyperlink to other sheet in excel I did it like
that:

Sheets(2).Activate
Range("a2").Hyperlinks.Add Range("a2"), "", "Control list", , "List"

but it doesn't work.

Can U tell me what's wrong???

regards,
sweet_dreams
 
D

davesexcel

You only need to post a message once, most of the excel crusers check
all the forums, this was answered in your other thread, :) :) :)
 
Top