I am trying to sum a series of rows in a column using VB and starting Excel

from the VB code.

I can do it OK if I set the values passed through as numbers e.g.

offset -6 to -1. The problem occurs when I don't know how many rows I've got

to add.

I keep a row counter in VB so I know where I started and I know where I have

got to but I don't know how to get Excel to accept this in a formula. When I

row_start and row_now but when it is stored in the Excel current cell it

gives an error because the variables do not have values.

Is there some way I can overcome this. I've thought of the following

options:

1. Store the row nos in a cell (but then I don't know the syntax to

substitute the values)

2. try and define a variable in Excel and set that - but again not sure how

to do this.

Is there just a simple way to use the syntax to make Excel take the right

values.

If anyone knows what I'm talking about and can suggest an answer would you

and the request is quite urgent.

Thanks in Advance

Best Regards

Tony Brown