Using " in an if statement

[288enzo]

I copied the formula I have in my spreadsheet to a module and am getting an error when I run the macro.

This is my formula:

Please Login or Register  to view this content.

This is what my macro looks like:

Please Login or Register  to view this content.

Error is - Compile error: Syntax error

I also tried:

Please Login or Register  to view this content.

Error is - Application-defined or object-defined error

The formula is in cell I19 which is merged with J19, K19, and L19, I wasn't sure if this had any barring.

Thanks for the help.

[ConneXionLost]

Try this:

Please Login or Register  to view this content.

[HaHoBe]

Hi, 288enzo,

double up the marks like

Please Login or Register  to view this content.

Ciao,
Holger

[AB33]

Wrong assumption

[288enzo]

Wrong assumption

I'm not sure who this is directed to as no one has mentioned anything about making an assumption. The constructive criticism isn't helpful.

[288enzo]

Try this:

Please Login or Register  to view this content.

Thank you, very helful. Makes perfect sense.

[288enzo]

Hi, 288enzo,

double up the marks like

Please Login or Register  to view this content.

Ciao,
Holger

Thank you Holger.

[AB33]

288enzo,
It was not directed at you. It was my own wrong assumption, hence for deleting the code.