View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default programmatically deselect a selection?

Something has to be selected. There is no way around that... You can avoid
moving teh active cell by using range objects. That tends to be a much better
way to go. Then you macro leaves the sheets exactly the way it found them,
without moving the focus.
--
HTH...

Jim Thomlinson


"Rich" wrote:

Hello,

If I programmatically select a range of cells -- Range("A1:D5").Select --
how can I deselect the selection without selecting another cell? I vaguely
recall something about range("A1:D5").copypaste = false. But I don't see
that anywhere in the dropdown. Any suggestions appreciated.

Thanks,
Rich