programmatically deselect a selection?

[Guest]

Hello,

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

Thanks,
Rich

 

[Guest]

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.

 

[Tom Ogilvy]

you have to select something else generally. You could select outside the
visible range.

 

[David McRitchie]

Hi Rich,
See Chip Pearson's page
http://www.cpearson.com/Excel/unselect.htm
macros for:
Unselecting A Cell Or Area -- unselectactivecell
UnSelecting An Area -- UnSelectActiveArea:

You aren't trying to deselect all selections, are you?

 

[Guest]

Thanks for the reference. Thanks all for your inputs. I know that something
needs to be selected. I discovered sht.Cells.Clear or
sht.Cells.ClearContents without having to select an entire sheet. But now I
can take it to areas with Chip Peason's method.

Thanks