check for selected columns in a macro

P

philip watson

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?
 
T

Tom Ogilvy

if selection.Address = selection.Entirecolumn.Address then

--
regards,
Tom Ogilvy

philip watson said:
Hello Excel Expert,

I wish to know how to write one or several lines of macro code that will
Click to expand...
test to see if any entire column
in a range of columns has been selected by the user of the macro before
Click to expand...
the macro is run. I would like
 
Top