Hey,

I know this has been gone over before but I'm still having a wee bit of
difficulty - I have a set of numbers which I need to sum every month but
every month the amount of numbers (one month it would be (sum c17:c22)
the next it could be (sum c17:c30) etc) in the set changes.

The set of numbers start on cell c17 and have another set of numbers
after them after a gap of blank cells.

So I'm thinking I need a range that will select the cells until it
comes to an empty one.. maybe a do while loop? and then I could just
put a sum funtion at the top..

Let me know if you have any thoughts.

Many thanks

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=541192