I'm trying to set up a dynamic list (processors will be added and removed constantly). I'm having issues with the name manager dynamically updating, I tried using =OFFSET(Processor List!$B$3,0,0,COUNTA(Processor List!$B$3:B),1) and it gives me a error. I'm sure I'm doing something wrong but I can't seem to figure it out, below is the code I tried using instead of the above formula. Thanks in advance for any help/advice!
Please Login or Register to view this content.
wyanrandy,
You'd be best off using a dynamic named range formula like you originally attempted. The error was because you never provided an ending row in your Counta() range. Instead of 'Processor List'!$B$3:B, try 'Processor List'!$B$3:$B$65000
Last edited by tigeravatar; 11-15-2012 at 03:14 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Please Login or Register to view this content.
The highlighted line still gives me trouble which is how I got into the mess I'm in - it gives me the Run-time error '1004':
Application-defined or object-defined error
If I remove this part it won't generate a drop down menu
Please Login or Register to view this content.
Dave: that worked perfectly thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks