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?

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?