View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StargateFanFromWork[_3_] StargateFanFromWork[_3_] is offline
external usenet poster
 
Posts: 77
Default Clear selection?

I've made do with using this for now:

ActiveCell.Offset(0, 0).Select

I'd found Selection.Clear, I believe it was, in the archives but when I
tested it, it literally wiped everything in the selection rather than just
removing the selection. In other words, even the conditional formatting was
removed, too. Is there something better than the above code, then, for
this? The above simplistic approach does the job, but it's probably a
ham-handed way of doing this.

Thanks! :oD