| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert text from one cell into formula in another cell. | Excel Discussion (Misc queries) | |||
| Using VBA to Insert a formula in a cell | Excel Programming | |||
| Insert value of formula into cell | Excel Programming | |||
| insert formula in last cell | Excel Programming | |||
| insert a new cell into an existing formula | Excel Discussion (Misc queries) | |||
![Ctech[_137_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
