|
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 |
Insert Formula in Cell with VBA
Range("Currency_cell").Formula = "=IF($D$43="""","""",$D$43)"
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ctech" wrote in message ... 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 |
| All times are GMT +1. The time now is 12:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com