LinkBack URL
About LinkBacks
foxguy 
You could define that name using non-volatile INDEX rather than the volatile OFFSET.
Name: myRange
RefersTo: =Sheet1!$B$12:INDEX(Sheet1$$B:$B, CodesCount, 1)
That should speed things up, but what is the definition of CodesCount?
You could define that name using non-volatile INDEX rather than the volatile OFFSET.
Name: myRange
RefersTo: =Sheet1!$B$12:INDEX(Sheet1$$B:$B, CodesCount, 1)
That should speed things up, but what is the definition of CodesCount?
Last edited by mikerickson; 04-21-2012 at 12:00 PM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks