Range of cell

  • Thread starter Thread starter Andres A
  • Start date Start date
A

Andres A

Hello everyone:

How can I know if the ranage selected is more than one
cell or a selection of diffrent ranges?

Cheers,

Andres
 
Andres said:
Hello everyone:

How can I know if the ranage selected is more than one
cell or a selection of diffrent ranges?

Cheers,

Andres
Click to expand...
RangeName.Count > 1
 
Andres,

Forgot to answer the first part of your question.

"selection.rows.count" AND "selection.columns.count" will tell you if there
is more than 1 cell in the range.

"Selection.cells.Count" gives the total number of cells in the total
selection.

regards

JohnI
 
Tom,

Thanks for that. I should have tested. I was going from memory which in this
case was faulty.

regards,

JohnI
 
Back
Top