Re: Worksheet_SelectionChange not firing
Quote from skywriter;768732Display More
The selection change event fires when you select a cell or range other than the one that was previously selected.
If A1 is currently the selected cell and I take my mouse and click on cell H1 then the event fires and the target cell is H1.
Are you confusing this event with the worksheet change event which fires when an actual change has been made in a cell.
For example I type "Hello World" in cell A1 and then hit the enter key and the worksheet change event fires and cell A1 is the target cell?
It is strange... it work only once and then the following error msg appeared:
"Run-time error '1004': Method 'Undo' of the object '_Application' failed"
Really have no clue of what is going on...