| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check for selected columns in a macro
Hello Excel Expert
I wish to know how to write one or several lines of macro code that will test to see if any entire colum in a range of columns has been selected by the user of the macro before the macro is run. I would lik the result of this test to return Boolean true or false. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check for selected columns in a macro
if selection.Address = selection.Entirecolumn.Address then
-- regards, Tom Ogilvy "philip watson" wrote in message ... Hello Excel Expert, I wish to know how to write one or several lines of macro code that will test to see if any entire column in a range of columns has been selected by the user of the macro before the macro is run. I would like the result of this test to return Boolean true or false. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA how to check if entire row is selected? | Excel Discussion (Misc queries) | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| Printing selected columns | Excel Discussion (Misc queries) | |||
| excel check boxes moving when excel selected cells pasted in word | Excel Discussion (Misc queries) | |||
| Columns Selected | Excel Discussion (Misc queries) | |||
Linear Mode
