newbie04,
If your data is split like that, with an empty line between, one way is to
use Data -- Subtotal menu to achieve what you want. That way Excel takes
care of which are real values and which are (sub) totals.

NickHK

"newbie04 " wrote in message
...
Hi nick,

okie, my original data is shown
2
5

1
0
3
6

2
9

And i wanna get the result:
2
5
7
1
0
3
6
10
2
9
11

I know the logic to scan the empty column and do the sum, but it seems
that z is not valid here. May i know why?

Worksheets(a).cells(i,j)Select
ActiveCell.formula = "=SUM(R[-z]C:R[-1]C)"


---
Message posted from http://www.ExcelForum.com/