Formula in Vba code help




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
And this is the line of code I'm trying to create
CoNOws.Range("Y" & COlrow + 3).Formula = "=( ""S" & COlrow &

Any help would be appreciated.

Rick Rothstein

Try it this way...

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

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