Thread: Referencing a cell, not the value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jjk jjk is offline
external usenet poster
  
Posts: 42
Default Referencing a cell, not the value
Try this.

objSht.Cells(Row, "U").Formula = "=Data!$B$1" & "* Q" & Row & ""

Regards,
Jayant

Reply With QuoteReply With Quote