Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselect or deselect cells
After a macro runs, sometimes a block of cells remains selected. Is
there a command I can put at the end of the macro to clear the selection? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselect or deselect cells
Set r = Selection
' your code here r.Select -- Gary''s Student - gsnu2007L "Fan924" wrote: After a macro runs, sometimes a block of cells remains selected. Is there a command I can put at the end of the macro to clear the selection? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselect or deselect cells
Perhaps this previous posting of mine (a response to another person using
Select/Selection type constructions) will be of some help to you in your programming efforts... Whenever you see code constructed like this... Range("A1").Select Selection.<whatever you can almost always do this instead... Range("A1").<whatever In your particular case, you have this... Range("C2:C8193").Select 'select cells to export For Each r In Selection.Rows which, using the above concept, can be reduced to this... For Each r In Range("C2:C8193").Rows Notice, all I have done is replace Selection with the range you Select(ed) in the previous statement and eliminate the process of doing any Select(ion)s. Stated another way, the Selection produced from Range(...).Select is a range and, of course, Range(...) is a range... and, in fact, they are the same range, so it doesn't matter which one you use. The added benefit of not selecting ranges first is your active cell does not change. -- Rick (MVP - Excel) "Fan924" wrote in message ... After a macro runs, sometimes a block of cells remains selected. Is there a command I can put at the end of the macro to clear the selection? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselect or deselect cells
On Feb 23, 2:50 am, Gary''s Student
wrote: Set r = Selection ' your code here r.Select -- Gary''s Student - gsnu2007L "Fan924" wrote: After a macro runs, sometimes a block of cells remains selected. Is there a command I can put at the end of the macro to clear the selection? This did not work for me. Maybe it is my version, excel 97 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect (Unselect) Cells | Excel Discussion (Misc queries) | |||
unselect cells | Excel Discussion (Misc queries) | |||
unselect cells | Excel Discussion (Misc queries) | |||
Unselect? Deselect? | Excel Programming | |||
Unselect Cells | Excel Programming |