run macro by changing cells value

[griisha]

Hi,

While I'm not all that bad with Excel I've got still a LOT to learn regarding VBA, so please forgive me bit noobish question...

I got a simple macro, I would like to run everytime any cell in column A (or at selected range) is changed. Can it be done??

Also, is there any way to refer to last changed cell (something like "ActiveCell", but refering not to the selected cell, but to the cell that was changed as last one)???

Thanks and Regards

Greg

[royUK]

Use the Worksheet_SelectionChange event

Please Login or Register  to view this content.

[davesexcel]

Hi,
This code would go into a worksheet module

Please Login or Register  to view this content.

This example refers to the first empty row after the last entry in column A

Please Login or Register  to view this content.

[griisha]

With your help it works as I wanted, so what can I say... You are my new Heroes

Thanks a lot for your help mates.

Greg