Formula string OK, formula not OK
I replaced the comma in my working solution with a ; as you had originally
used that, I assumed that was your setting. Perhaps you need comma also, try
ActiveCell.Formula = "=HYPERLINK(""#" & Sheets(1).Name & _
"!D1"",""" & Sheets(1).Name & """)"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Roman" wrote in message
oups.com...
Does not for me... shhh... But thank you anyway.
I am always geeting 'Application defined or object defined error'
Any idea?
|