named range not specific to worksheet
 

i have a workbook that continually has sheets added to it, often rows are
inserted or removed on the sheet, which shifts the position of the cell i
need to address

is there a way to create a named range that is not specific to a worksheet

i.e.: the name refers to: B36 on whatever the active sheet is..

....why not just say "B36" ?
.... if the user inserts a row at 35:35, the reference would move down 1 row
to B37, and i would want the name to refer to that new address... (which
would not be correct on a different sheet where the cell to be referenced
was at a different position;
....and now i see the implicit problem in the logic... ! );

any direction?

thanks in advance...
mark

named range not specific to worksheet
 

I think the closest thing you can use is the worksheet level names. Then you're
"basename" would be consistent across all the sheets, but the names will follow
the cell.



Mark Kubicki wrote:

i have a workbook that continually has sheets added to it, often rows are
inserted or removed on the sheet, which shifts the position of the cell i
need to address

is there a way to create a named range that is not specific to a worksheet

i.e.: the name refers to: B36 on whatever the active sheet is..

...why not just say "B36" ?
... if the user inserts a row at 35:35, the reference would move down 1 row
to B37, and i would want the name to refer to that new address... (which
would not be correct on a different sheet where the cell to be referenced
was at a different position;
...and now i see the implicit problem in the logic... ! );

any direction?

thanks in advance...
mark

--

Dave Peterson