Very Computer

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

Not sure if I have understood, but try something like:

            Set rngRange1 = .Range("A1", .Range("A1").End(xlDown))
            strRange1 = rngRange1.Address

JSF