How to preserve cut/copy range on SelectionChange event?

P

pH7

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SelectionChange Event Glitch 1
SelectionChange Event 5
How to retrieve the last selected cell before SelectionChange even 2
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Copy Array to Array, how to and should I? 13
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0
How to adjust or resize a range? 3
Simple Copy to and From Cells With IF statement. 3

Top