need help with strings and excel forumla's

[jadedinvasion]

I've got a bit of a head scratcher on my hands. I want to assign a formula to an cell on an excel spreadsheet, but the formula itself contains " (example below)

objWB.Worksheets(1).Cells(10, 17) = "=SUMIF(B10:M10,">0")/COUNTIF(B10:M10,">0")"

Obviously this isn't going to work. I tried being sneaky and changed the " to ' but that didn't work either.

I was wondering if i could possibly assign the ascii value for " to a string variable and include the necessary punctionation that way.

Any idea's how to get around this?

Thanks,

 

[firefytr]

To use a quote in a formula (or anything 'physical', ie in the worksheet) via VBA, you'll need double quotes. Instead try ...

objWB.Worksheets(1).Cells(10, 17) = "=SUMIF(B10:M10,"">0"")/COUNTIF(B10:M10,"">0"")"

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[jadedinvasion]

Ah! This totally worked. Thanks for your help!

 

[firefytr]

You're very welcome.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci