I working in an area on a spreadsheet that can have a variable number of
rows. The user can add and subtract rows, as needed. Now, I m developing a
function that will "walk" down through these rows each time some data is
changed. In the "static" number of rows, it's fairly easy. I just walk down
through the rows, top to bottom, because I know exactly where the first row
is and where the last row is.

Now in the variable row case (real world) I don't know. I using a "Named"
column and that will work except where the user adds a row at the very
beginning or at the very end. The "Named" column doesn't pick up the new
rows when they are added at the very beginning or the very end.

So, I have changed the "Named" column to include the row immediately before
and immediately after. Then I am safe. However, I still only want to search
the rows of interest, so I am trying to find some way to adjust the size of
the named column by changeing the beginning row to the next row(A3 - A4)
and the end row up one (A304 - A303). If this is what I have to do, how do
I do it?

Or, perhaps you guys and gals can suggest a better way.

Thanks very much for your help..