I am writing an Excel function in VBA, but I am stuck on this:

I need to count the number of series in a range:

A column has a several ranges of numbers, split by blank cells:

1
0.5
1


1
1
1
1
1

1
1

I need to count the series of numbers, which in this case 3: (1, 0.5,1
and (1,1,1,1,1) and (1,1)

How do I do this from a passed range in VBA, please

Thank

--
rjhar

-----------------------------------------------------------------------
rjhare's Profile: http://www.excelforum.com/member.php...fo&userid=1141
View this thread: http://www.excelforum.com/showthread.php?threadid=47293