View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J Streger J Streger is offline
external usenet poster
 
Posts: 101
Default Saving copied info while running a Selection Change Macro

I am using the Worksheet_SelectionChange subroutine to change the contents of
a cell dependent upon the location of the active cell. This has the
unfortunate side effect that eliminates the ability to copy/cut and paste,
except for fill right/down.

I know how to determine if the selection change was preceeded by cut/copy
(by seeing if the application is in cutcopymode), but I wanted to know if
there was a way to capture the copied/cut information into a variable prior
to it being lost by the rest of the code. I assume a property saves this
information as a string or array but I can;t find it. thanks!
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003