check for selected columns in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
VBA set thick borders around non empty cells in range 0
Macro to Hide/Unhide various columns 5
Run macro from active workbook whose name keeps changing 20
conditional format based on column statistics and loop over columns 1
Advice on multiple macros, same code just a different column 9
Comparing two columns 7
ThisWorkbook.Close crashing Excel (2010) 11

Back
Top