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.
Bookmarks