check for selected columns in a macro

[Guest]

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?

 

[Tom Ogilvy]

if selection.Address = selection.Entirecolumn.Address then

--
regards,
Tom Ogilvy

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