Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining the size of a range.
Is there a means for discovering the size of a particular range? (Like, how
many rows or columns are in the range.) (Using VBA, of course.) -- from Dave the wave~~~~~ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining the size of a range.
iRows=Selection.Rows.Count iColumns = Selection.Columns.Count -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dave the wave" wrote in message ... Is there a means for discovering the size of a particular range? (Like, how many rows or columns are in the range.) (Using VBA, of course.) -- from Dave the wave~~~~~ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining the size of a range.
Thanks!
-- from Dave the wave~~~~~ "Bob Phillips" wrote in message ... iRows=Selection.Rows.Count iColumns = Selection.Columns.Count -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dave the wave" wrote in message ... Is there a means for discovering the size of a particular range? (Like, how many rows or columns are in the range.) (Using VBA, of course.) -- from Dave the wave~~~~~ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining the size of a range.
Dave,
Try this Dim rngTest as range set rngTest = selection debug.print rngTest.Count 'number of cells debug.print rngTest.Columns.Count 'number of columns debug.print rngTest.Rows.Count 'number of rows Robin Hammond www.enhanceddatasystems.com "Dave the wave" wrote in message ... Is there a means for discovering the size of a particular range? (Like, how many rows or columns are in the range.) (Using VBA, of course.) -- from Dave the wave~~~~~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining Frequency of range | Excel Worksheet Functions | |||
Excel VBA - determining range | Excel Programming | |||
Determining last copied range | Excel Programming | |||
Determining range | Excel Programming | |||
Determining end of user-selected range | Excel Programming |