Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.inputbox for another workbook
Hi
I need to select two ranges. One range comes from the current workbook. Another from a separate workbook. The following code helps me select ranges from different worksheets within the same workbook but I cannot seem to move to another workbook. What could be going wrong? Please help! Thanks Utkarsh ***************** Sub comp1() Dim FirstRange As Range Dim SecondRange As Range 'snip snip Set FirstRange = Application.InputBox("Set first series: ", Type:=8) Set SecondRange = Application.InputBox("Set Second series: ", Type:=8) 'snip snip end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputbox and Application.InputBox | Excel Programming | |||
inputbox and application.run macro1 | Excel Programming | |||
application.inputbox | Excel Programming | |||
Application.Inputbox Question | Excel Programming |