Column ref - quick question

[EnergyEngineer]

If I have

Please Login or Register  to view this content.

I don't think it works. do I have to do target.address then get the column? Ugh this should be easy...

I want if the target cell is in the 15th column then...

~RUTH~

[VBA Noob]

Are you using a event macro.

See if this example helps.

Please Login or Register  to view this content.

When you select Col O it triggers the message box

VBA Noob

[EnergyEngineer]

I don't think this works.

Please Login or Register  to view this content.

That is my question.

But yes it is an event when any cell is changed in column 15. Not if the entire column changes.

Thanks,
~RUTH~

[VBA Noob]

It did for me.

Did you try my code ??

VBA Noob

[EnergyEngineer]

So column P (=16) is what I was really after not O. I need to learn how to count better :-)

Thanks for your help,
~RUTH~

[VBA Noob]

No problem.

It's the easy one's that cause the biggest problems

VBA Noob