Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty selection with vba
How can I hide the selected cell? For example, if I have selected one cell
and my VBA code execution ends and I don't want that the last selected cell is selected anymore. How can I do it with VBA? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty selection with vba
Maybe
Range("A1").Activate Mike "VBA beginner" wrote: How can I hide the selected cell? For example, if I have selected one cell and my VBA code execution ends and I don't want that the last selected cell is selected anymore. How can I do it with VBA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty selection with vba
Something is always 'selected' in a worksheet, so if you don't like the
current selection you have to select something else, as Mike demonstrated. Btw though, most actions can be performed in VBA without changing the selection. New coders often write: Range("A1").Select ActiveCell.Font.Bold = True but all that's needed is: Range("A1").Font.Bold = True -- Jim "VBA beginner" <VBA wrote in message ... | How can I hide the selected cell? For example, if I have selected one cell | and my VBA code execution ends and I don't want that the last selected cell | is selected anymore. How can I do it with VBA? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection range to last non empty cell | Excel Programming | |||
finding empty selection | Excel Programming | |||
Test for an empty selection | Excel Programming | |||
List Selection to First Empty Row | Excel Programming | |||
Selection of non-empty cells | Excel Programming |