View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Utkarsh Utkarsh is offline
external usenet poster
 
Posts: 18
Default 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