add hyperlink without changing the cell formating
Use the following:
The application object has a property
(Application.AutoFormatAsYouTypeReplaceHyperlinks )which decides
whether excel will replace the formatting of the cell where one URL or
mail id present
The advantage is that it will be applicable for all such cell.You need
not change the font of all cell containing the URL/Mail Id.
Application.AutoFormatAsYouTypeReplaceHyperlinks=F alse
Activesheet.Hyperlinks.Add anchor:=range("H:"&i),Address:="http://
blahblahbla"
|