Solved Inserting multiple double quotes in a cell using VBA

June 8, 2019 at 16:55:31
Specs: Windows 7
I have the following formula that I want to insert into a cell but it has multiple double quotes and I can't seem to make it work. There is plenty of solutions on the web but most have 1 or 2 sets of double quotes. I tried double quotes on all double quotes but it gives me a runtime error 438 object doesn't support this property

Here is the formula that is want to insert:
="Closing Costs" & " Current Buffer" & " " &TEXT('Closing Costs'!D32,"$ 0")
Here is the code that is not working:

ActiveSheet.Range("F18").Value = "=""Closing Costs"" & ""                             Current Buffer"" & "" "" &TEXT('Closing Costs'!D32,""$ 0"")"


See More: Inserting multiple double quotes in a cell using VBA

Report •

#1
June 8, 2019 at 20:13:23
✔ Best Answer
You don't insert a formula by using .Value, you insert a formula by using .Formula.

You could just record a macro while entering the formula in a cell and seeing how the recorder writes the VBA version.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question