Testing Range Extent
 

Hi All
How can I test in VBA if the selected range is a single cell or multiple
cells or multiple range of cells?

Many thanks

Cheers

Testing Range Extent
 

Sub howmany()
MsgBox (Selection.Count)
MsgBox (Selection.Areas.Count)
End Sub

--
Gary''s Student - gsnu200722

Testing Range Extent
 

Many thanks

"Gary''s Student" wrote:

Sub howmany()
MsgBox (Selection.Count)
MsgBox (Selection.Areas.Count)
End Sub

--
Gary''s Student - gsnu200722