View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dannyboy dannyboy is offline
external usenet poster
 
Posts: 3
Default macro to copy & paste cell data into another cell

Hello;
I want to copy & paste the cell data when any cell in the worksheet
gets selected. I would like to have the data stored in a list either on the
same worksheet or in another worksheet. I have the selected cells background
color change when selected but having trouble putting the cells contents into
another cell.