By VBA, How to know User has selected one or several entire rows orther than some c

  • Thread starter Thread starter Amolin
  • Start date Start date
A

Amolin

By VBA, How to know User has selected one or several entire rows orthe
than some cells
 
To check that at least one entire row is selected, you can count the
columns in the selection

Selection.Columns.Count = ActiveSheet.Columns.Count
 
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

Highlight more than one entire row when cells = TRUE 5
How to sort entire spreadsheet by one column sort 5
select case 6
Deleting Rows - only deletes content 2
collate rows from several files into one new master file 1
Locked Several Worksheets, allow format cells/select unlocked cell 2
Change all of the cells in a row(s) by a percentage 4
Need help deleting data 2

Back
Top