Hey everyone;
Writing up some code, and I have a workbook with many named ranges. Question is simple...
Are named ranges a part of a collection object that I can use?
Looking to do something like:
Bonus points if you let me know how to determine collection objects on my own in the future!
Please Login or Register to view this content.
Last edited by Miraun; 05-27-2014 at 12:29 PM.
Going for Guru! Click the Star to the bottom left of this post if I helped!
they are in application.names
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Give us some reputation then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks