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)) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select range through Inputbox
You can capture the full address, like this
RangeAddress = varRange.Address(External:=True) [BookName]SheetName!$A$1 Note might get additional apostrophes depending on the names A better way, rather than pass the address, pass the range object. Then you can work with rng.Parent.Parent ' the workbook rng.Parent ' sheet but you might not need either the above, simply use the range object. Regards, Peter T "Bythsx-Addagio" wrote in message ... 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)) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select range through Inputbox
Try this change
from: RangeAddress = varRange.Address to: RangeAddress = varRange.Address(External:=True) "Bythsx-Addagio" wrote: 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)) |
Reply |
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 |