Apologies if this is answered elsewhere - the 'search' function wouldn't co-operate.
I'm trying to make a DNR that will expand to however many columns AND rows are there.
=OFFSET(Quotes!$B$5,COUNT(Quotes!B5:B1000),
COUNT(Quotes!B5:CC5),0,0)
The B5:b1000 should be the rows I'm covered within, and the B5:CC5 should cover the columns, no? All help is very much appreciated!
Are the columns of unequal length or does the number of rows in the first column dictate length for all ? If so I would probably go for:
=OFFSET(Quotes!$B$5,0,0,COUNTA(Quotes!$B$5:$B$1000),COUNTA(Quotes!$B$5:$CC$5))
Note the differences, the last two parameters are optional and specify height & width - this is what you need to set.
Last edited by DonkeyOte; 06-26-2009 at 01:13 PM. Reason: added 0's to avoid confusion
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks DQ, will lookup this QUOTA and figure it out for next time. Cheers and thanks. L
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks