Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You don't need to select to clear a cell or a range.
ActiveCell.Offset(0, 0).ClearContents However, if you are setting row/column to 0 then just use ActiveCell.ClearContents HTH Regards, Howard "StargateFanFromWork" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How To Clear Previous Selection From a Drop Down | Excel Discussion (Misc queries) | |||
clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
How do I clear a print area when the selection is grayed out? | Excel Discussion (Misc queries) | |||
Fast way to clear Listbox selection | Excel Programming | |||
How to clear a selection | Excel Programming |