Hello folks
I've got two User Defined Functions (see below) that give me the Worksheet and Refers To range for a list of named ranges in my workbook. However these only work for Defined Names and not Tables. What should I do to amend these UDFs so that I also get the Worksheet and Refers To Range info for tables please?
Thanks
Please Login or Register to view this content.
Kenny
Try this:
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks