Adding Formnula in VBA - Run-time Error 13

[Webbers]

Hi all,

I ran into a snag, and I have been trying to resolve this on my own most of the day.... unsuccessfully. I do not understand why this is happening. Attached are 2 screenshots showing the error and where within the code. The code is below as well as within the sample workbook. Thanks in advance!

Please Login or Register  to view this content.

[Fluff13]

You need to double-up all the quotes inside the formula, like

Please Login or Register  to view this content.

[MarvinP]

Hi Webbers,

We've all struggled with this formula to VBA problem. Here is my solution. Make the formula work in the Excel sheet itself, then copy the formula using the keyboard buffer.
Then move to VBA and to the Dot Formula = part first. Then put a quote and paste the formula and a quote at the end.
I see you missed the ...formula = "= .... in your picture above.
Then for every quote you have in your formula make it a double quote.
https://docs.microsoft.com/en-us/off...ng-expressions

Hope that helps. If not then keep asking.

[jolivanes]

Enter the formula in a cell
Select the cell
Tools, Macro, Record Or Developer - Record Macro (Give the macro a recognizable name here)
F2, Enter
Go into your module and your formula is there as a macro (including double upped quotation marks if needed.)

[Webbers]

You need to double-up all the quotes inside the formula, like

Please Login or Register  to view this content.

Fluff13,

I looked at the formula for this line side by side with your corrected version to see where I went wrong. I was like "half-way" there basically, it seemed in the areas where I has a space and dash, I used only single quotes rather than the double quotes there too. I have learned a lot since you helped me with this the very 1st time and I did not use double quotes at all. Thanks so much!!!!

[Webbers]

Thank you @MarvinP and @jolivanes!

[Fluff13]

Glad to help & thanks for the feedback.