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?