View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elaine Elaine is offline
external usenet poster
 
Posts: 106
Default Delete all entries in selection except activecell

How can I delete all entries from a selection except for the currently active
cell?

In other words, if I have selected the range (A3:a12), I would like to
retain the value of A3 but delete the contents of all other cells.

Thanks for your help.