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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.inputbox for another workbook
Add this:
Workbooks("Yourbook2.xls").Activate Between the to input box statements. and this after the second inputbox statement: Thisworkbook.Activate Charles Chickering Utkarsh wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.inputbox for another workbook
Thanks Die_Another_Day
In my case the file name and location keeps changes. Would appreciate a more general solution. |
Reply |
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 |