Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to preserve cut/copy range on SelectionChange event?
I have a Worksheet_SelectionChange event handler that manipulates som
graphic objects – usually not a problem. However, if the user ha selected a cell, done a copy or cut and then clicked on another cell i anticipation of doing a Paste, then my macro screws up the pending cu or copy range. I want to save the copy range on entrance to the macr and restore it just before exit, but the target parameter to th SelectionChange event handler is the new range. How can I find th range that was selected before the user clicked on the new cell -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use selectionchange instead of doubleclick event? | Excel Discussion (Misc queries) | |||
Worksheet SelectionChange Event | Excel Discussion (Misc queries) | |||
Disable SelectionChange Event | Excel Discussion (Misc queries) | |||
Excel Automation SelectionChange event | Excel Discussion (Misc queries) | |||
SelectionChange Event | Excel Programming |