Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "David McRitchie" wrote: 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? --- HTH, David McRitchie, Microsoft MVP - Excel "Rich" wrote in message ... 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deselect row/column from multiple selection | Excel Discussion (Misc queries) | |||
select all, deselect these | Excel Discussion (Misc queries) | |||
Programmatically add shapes to a selection | Excel Programming | |||
ActiveChart.Deselect won't Deselect | Charts and Charting in Excel | |||
Programmatically add shapes to a selection | Excel Programming |