View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sweet_dreams sweet_dreams is offline
external usenet poster
 
Posts: 2
Default hyperlink in excel vba

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