When I use the inputbox function to get a range the range that is returned is not associated to any particular worksheet. Is there anyway to return both the range address and the name of the worksheet which contains the selected range. Or anyway at all to get the worksheet without having to manually input the name? The parent property doesn't work because as I said, the range that is returned seems to be just a cell address.
Hello SidewinderAM9M,
Please post your code. It will help you get a correct answer and more quickly.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
The code works great as long as the active worksheet is "BOM". Other wise I get a "subscript out of range" error at
Please Login or Register to view this content.
How do I mark a post as [solved]?Please Login or Register to view this content.
Mods note: "If your question is resolved, mark it SOLVED using the thread tools"
Last edited by FDibbins; 05-16-2013 at 12:08 AM. Reason: you had the / after the word CODE :)
So does anyone have any ideas. I really want to know how to return the name of a workbook who's name cannot be predicted... from an Input box or some kind of non-manual entry. There has to be a way.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks