LinkBack URL
About LinkBacks
Using two named ranges would be one approach
Name: myColumn
RefersTo: =OFFSET(xxx!$A$1,0,MATCH(xxx!I28,xxx!$A$1:$H$1,0)-1,ROWS(xxx!$A:$A),1)
Name: myDynamicRange
RefersTo: =OFFSET(myColumn,0,0,COUNTA(myColumn),1)
Using two named ranges would be one approach
Name: myColumn
RefersTo: =OFFSET(xxx!$A$1,0,MATCH(xxx!I28,xxx!$A$1:$H$1,0)-1,ROWS(xxx!$A:$A),1)
Name: myDynamicRange
RefersTo: =OFFSET(myColumn,0,0,COUNTA(myColumn),1)
Last edited by mikerickson; 05-01-2008 at 03:41 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi,
Thanks for repyling, however i can't get this to work, can you try it for me and attach it back?
Thanks
When using relative refereneces in Names, it is imported to select the proper cell before defining the Name. In the attached, J28 was active when myColumn was defined, so myColumn (and myDynamicRange) is the column whose header matches the cell to the left of the formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks