Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select range through Inputbox
Hello,
I am using the below code to prompt the user to select a range of cells. My problem is that the resulting range is ignoring any workbook reference. If you select a range on a different workbook it ignores that in the following function. How can I capture the absolute reference? Thanks in advance! Set varRange = _ Application.InputBox("Select a range of cells:", Type:=8) If IsObject(varRange) = False Then Exit Sub RangeAddress = varRange.Address ' Call nested function to return list of unique items varUniqList = UniqList(Range(RangeAddress)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Select Range off sheet from inputbox | Excel Discussion (Misc queries) | |||
Trouble Using InputBox Method to Select Range from Other Sheets | Excel Programming | |||
Select range with InputBox. Is it possible? | Excel Programming | |||
InputBox to select cell locations | Excel Worksheet Functions | |||
Inputbox - Select ranges | Excel Programming |