How to remember a copied range
Hi
I have written a macro for end-users to run on their PCs but each time they do so it means that the CutCopyMoode resets to false and they have to re-copy any area they had copied beforehand. I want my macro to remember any area that they may have previously copied so that I can reinstate the Copy mode once the macro has finished.
I would assume the idea would go something like:
If Application.CutCopyMode = xlcopy then
CopyArea = ..... 'Remember copied area outlined in moving dashes
else
CopyArea = ""
endif
Call MainMacro
if CopyArea <> "" then Range(CopyArea).Copy 'Reinstate copied area
Can anyone fill in the dots in my above macro?
|
