OFFSET troubles...
Posted by Todd Kasenberg on August 14, 2001 6:16 AM
I have named a dynamic range using offset...here is the formula:
=offset($l$1,0,0,29,count($o$4:$e$z4)). My obvious goal is to select an area from L1 that extends 29 rows deeps, and that could extend as far as ez4, but I want the range to end with the last cell that has a number.
So far, so good.
However, after accepting this for a named range, Excel automatically puts the sheet reference in, so it looks like this:
=offset(sheet1!$l$1,0,0,29,sheet1!$o$4:$ez$4)).
This is counterproductive to me...I want the page to be relative, in other words, i want the dynamic range to refer to the current page, and not the fixed page which was active when I defined the name.
Anyone see a solution to my impasse?