nastech wrote:
Must be some way to point to a new row, from something like:

=CELL("row",A500) to be able to reference in the same formula,
add plus or minus lines. open to any function that would do that..

cell? row? line.. offset? do not know how to put together. thanks.

You could use a dynamic range, or you could use OFFSET. You need to give us
more information about what it is you are doing.