Creating Hyperlink in excel 2003 VBA
Hi all,
I was trying to create hyperlink to other sheet in excel I did it like
that:
Sheets("Index").Activate
Range("a2").Hyperlinks.Add Range("a2"), "", "Control list", , "List"
where "Control List" is the name of sheet I am trying to open
but it doesn't work.
Can U tell me what's wrong???
regards,
sweet_dreams
|