how to put " in a cell thru macro

T

Tang

i want to put "=if(a1="","",a1)" in cell B1 thru macro, but get error
message.

the macro line is as follow:
range("B1").value = "=if(a1="","",a1)"

hope someone can give your guidance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
=substitute 2
Merging cells and formats 8
How to set tabs in work document 0
If Not blank - Formula for two cells 0
Function for summing or counting cells based on a specified fill color 3
Show value from one cell in another cell if today falls between a date range 5
Referencing the values of multiple cells in conditinal formatting. 0

Top