Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Range Extent
Sub howmany()
MsgBox (Selection.Count) MsgBox (Selection.Areas.Count) End Sub -- Gary''s Student - gsnu200722 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Range Extent
Many thanks
"Gary''s Student" wrote: Sub howmany() MsgBox (Selection.Count) MsgBox (Selection.Areas.Count) End Sub -- Gary''s Student - gsnu200722 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing if a cell is within a range | Excel Programming | |||
Testing a range for blanks | Excel Programming | |||
Testing Range from other Sheets | Excel Programming | |||
testing whether the ActiveCell is in a given range | Excel Programming | |||
Defining Range Extent | Excel Programming |