Formula in Vba code help

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

HI,

I'm turning to the forum once again for help.
I'm trying to write a formula in VBA, and I think it may be a sequence
of where I need to place the " " " with in the code.
This is what the formula looks like in the work sheet
=(S14="Filled")
And this is the line of code I'm trying to create
CoNOws.Range("Y" & COlrow + 3).Formula = "=( ""S" & COlrow &
"=""Filled"")"

Any help would be appreciated.
 
Try it this way...

CoNOws.Range("Y" & COlrow + 3).Formula = "=(S" & COlrow & "=""Filled"")"
 
Back
Top