Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining number of Ranges
I'm new to VBA and I have a worksheet where I need to determine the number of
contiguous blocks of cells with data in them. There could be two to four blocks. All of the blocks will be within Range A1:I25. I thought I could use Areas.Count so I set up a test Sub with three blocks of cells. Here is the sub: Sub CountAreas() Range("A1:C7").Value = 9 Range("F9:I16").Value = 10 Range("A21:D25").Value = 12 Range("A1:I25").Select x = Selection.Areas.Count Range("A30").Value = x Debug.Print x End Sub The value of x is 1 when I run the sub. I thought it should be 3. Any help on what I'm doing incorrectly would be apprciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determining number of columns of 2 different ranges | Excel Programming | |||
need help determining a row number | Excel Programming | |||
Determining if two ranges overlap | Excel Programming | |||
Determining new category number | Excel Programming | |||
Determining Row Number | Excel Programming |