named range not specific to worksheet

[Mark Kubicki]

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]

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.