runtime error '1004' application-defined or object-defined error

Hi,

I'm trying to use this code in a vba module:

Please Login or Register  to view this content.

However, when i run it i get the error "runtime error '1004' application-defined or object-defined error". Can anyone help me with what's going wrong here please?

thanks in advance!

Personally, I find it easier to use CHR(34) (The ASCII value for ") rather than trying to double up, or even treble up, on " characters...

Please Login or Register  to view this content.

Thanks Cytop, that worked great!

romperstomper - as for the lack of double quotes on the A1 cell, I was finding that it wasn't detecting blank cells with two sets of quotes, but it did with just the one set of quotes. That was when i was testing the formula manually in the worksheet though. I'm not sure why that was, but it wasn't detecting the condition as true when it was. The original formula had two sets of double quotes, but didn't seem to be working.