Determining number of Ranges
Thank you very much for the reply Dave. I explain a little more why I
selected stuff in my reply to Don's 2nd post. the data won't always be in the
three ranges I designated. one set of data could be in be in B9:E13, for
example. Thank you again.
"Dave Peterson" wrote:
I'm not quite sure why you're selecting stuff, but here's another option:
Range("A1:C7,F9:I16,A21:D25").Select
MsgBox Selection.Areas.Count
Jimmy O wrote:
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.
--
Dave Peterson
|