Thread: Formula string OK, formula not OK
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roman[_4_] Roman[_4_] is offline
external usenet poster
  
Posts: 93
Default Formula string OK, formula not OK
Please, anybody, donīt you know why this does not work for me?

ActiveCell.formula = "=hyperlink(" & """" & "#'" & Sheets(1).Name &
"'!D" & "1" & """" & ";" & """" & Sheets(1).Name & """" & ")"

Thanks in advance.

Reply With QuoteReply With Quote