Counting selected cells

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Hi

How do I count how many cells the command Range(Selection,
Selection.End(xlToRight)).Select has selected?

Thanks

Wendy
 
Try

Msgbox Range(Selection, Selection.End(xlToRight)).Cells.Count
 
After running that line it would just be

Selection.Cells.Count

Tim
 
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

File Name changes with dates and Deleting Rows of Zeros 0
Count no empty cells at the right of a selection 2
copy range to a variable. 6
Insert cells 1
Sort current range by column j 1
Naming variable range selected by cursor movement 2
select pivot table range 1
Macro Button to Sort Columns - Troubleshooting ideas? 1

Back
Top