View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ABelect ABelect is offline
external usenet poster
 
Posts: 1
Default Copy and Paste Macro

I am attempting to create a macro to copy and paste. The cells I need to
copy are not adjacent to each other. I used the Ctrl key to select the cells
but I get an error that it cannot be done. How do I select and copy these
non-adjacent cells in a macro?