Macro to write Formula to cells

**CityMPLSEmpolyee** · 06-10-2011, 09:57 AM

I am tiring to have a macro write a list of Formulas to cells and when I run it I get a Debug Error. What is wrong with my code?

Please Login or Register  to view this content.

**ChemistB** · 06-10-2011, 10:15 AM

I know what's happening. I'm not sure what the fix is outside of changing your formulas.

VBA is seeing your second " as the end of the formula

Please Login or Register  to view this content.

If you replace your "" with 0 for example

Please Login or Register  to view this content.

It works fine.

**CityMPLSEmpolyee** · 06-10-2011, 10:28 AM

Thanks, that works.
But why is it that we can't enter in a blank through the macro, when in the cell I can write the Formula to enter blank?

**MarvinP** · 06-10-2011, 10:39 AM

Hi,

My rule is when trying to convert an Excel formula to a VBA formula in the .Formula = line is to double every quote mark after putting a Quote at the front and end of the Excel Formula.
Example: A cell formula of:

Please Login or Register  to view this content.

Changed to a VBA formula looks like this:

Please Login or Register  to view this content.

Put quotes in front of the equal sign and at the end and double every quote in between.

I think you will see that the """" will turn into a "" after the code is run. This would be the blank you are looking for.

Hope this helps.

**CityMPLSEmpolyee** · 06-10-2011, 10:40 AM

ChemistB
I found your post
"Inputting a formula which contains Quotes" this was the way I should have posted it
read the replay you got, and that works as will,
when I tried it I put in too many ".
your help was great, Thanks