Target.Column problems

[james.benham]

Im having some trouble with Target.Column / Target.Row syntax.

The code below is a snippet of a conditional formatting problem that I posted about yesterday. I have been working on it since but cant seem to get it too work.

When the if statements read:

Please Login or Register  to view this content.

rather than

Please Login or Register  to view this content.

They work, but obviously this is only relevant for column O.

Any idea what I'm doing wrong??

Please Login or Register  to view this content.

[DonkeyOte]

Target.Column will return the number of the column so assuming Target was in P:

Please Login or Register  to view this content.

will translate as

Please Login or Register  to view this content.

which is obviously not valid syntax... you should perhaps revert to Cells based approach (R1C1) given it is significantly more flexible than using Range

Please Login or Register  to view this content.

equates to

Please Login or Register  to view this content.

which is R1C1 - ie Row 15 Column 16 which is equiv. to P15