| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don't run if entire column is selected
I have a small macro which formats selected cells. How I can get an error
message if an entire column is selected? I don't want all 65000 odd cells in that column to be formatted. I see that Columns("E:E").Select selects all cells in column E but I don't know in advance which column will be selected as the format macro will work on any block of cells selected. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA how to check if entire row is selected? | Excel Discussion (Misc queries) | |||
| how to colour the entire row with the selected word | Excel Discussion (Misc queries) | |||
| Macro to print a selected range, not entire worksheet | Excel Discussion (Misc queries) | |||
| I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
| Highlight the entire row of a selected cell | Excel Programming | |||
Threaded Mode
