Worksheet Selection Change not working

Can't see why following Code isn't firing when a relevant cell in Col C is selected.

I've ensured the "Immediate" window shows Application.EnableEvents = True

Clicking a green cell should cut the relevant name in Col A, paste it to the next free row in Sheet 5, then move the cells up to "close the gap"

Please Login or Register  to view this content.

Any suggestions, pointers or solutions welcome as ever.

Ochimus

The key problem was with

Please Login or Register  to view this content.

You used it twice, while column A is empty. so first you moived empty cell to second sheet, and then deleted this empty cell and moved the rest of empty column up. Not easy to notice :-)

Try this way:

Please Login or Register  to view this content.

There is Polish proverb: Najciemniej jest pod latarnią (direct translation: It's darkest just below streetlight, so: we tend to not spot things which are in plain view, we focus on looking in dark/hiddem spots :-) ).
And I shall confess, it's quite common situation I face in programming myself.

As for debugging tips, see http://www.cpearson.com/excel/DebuggingVBA.aspx

PS. Thanks for marking thread SOLVED