Thread: Insert Formula in Cell with VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ctech[_137_] Ctech[_137_] is offline
external usenet poster
  
Posts: 1
Default Insert Formula in Cell with VBA

Hi

Range("Currency_cell").Formula = "=IF($D$43="","",$D$43)"

This formula get incorrect in the cell.. it turns out like
=IF($D$43=",",$D$43)
So some of the "" are missing... how do I get around this..


Cheers


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=529951

Reply With QuoteReply With Quote