Thread: cell.formula returns value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gleam Gleam is offline
external usenet poster
  
Posts: 87
Default cell.formula returns value
I have this line of code:
MyStr = Cells(12 , "D").Formula

I expect it to return "=D11 + D7" but it reurns the the value Cells(12 ,
"D").Value

How do I get the formula?


Reply With QuoteReply With Quote