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
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
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
If anyone knows what I'm talking about and can suggest an answer would you
and the request is quite urgent.
Thanks in Advance