Formula in Vba code help
 

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.

Formula in Vba code help
 

Try it this way...

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

--
Rick (MVP - Excel)


"Charles" wrote in message
...
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.

Formula in Vba code help
 

On Jan 19, 11:30*am, "Rick Rothstein"
wrote:
Try it this way...

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

--
Rick (MVP - Excel)

"Charles" wrote in message

...

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.

Thanks Rick that was what I was looking for.