View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_139_] John[_139_] is offline
external usenet poster
 
Posts: 19
Default add hyperlink without changing the cell formating

In a macro I am adding hyperlinks using the following code:

Cells(i, "H").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="http://blahblahbla"

Is it possible to add a hyperlink in this fashion without changing the
formating of cell?

Thanks for looking.