Formula in Vba code help

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.
 
R

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

Similar Threads

Concatenate with Underscore in formula 2
Help Converting Cell Formula To VBA Code 5
adding formula to vba code 1
VBA Formula Syntax 5
Vlookup in VBA 3
Array Formula in VBA 2
translating worksheet formula into VBA 2
Help with my code and formula 1

Top