Select range in different workbook

Cheers all!

Could you please help me with this one:

I need to allow the user to select a range in a different workbook than the one where the code is running.

So, the user clicks on a button to start the application, and sees a prompt to select a range with data.
This range will be in a different workbook from where the application is running.

I tried the Application.Inputbox method and the RefEdit control but failed (neither allows you to select a range in a different workbook, or so i figured).

Thank you for your time,
Alex

Hello Alex,

It would be helpful to know wether the other workbook is opened or closed. If so you simply need to qualify your range object with the workbook name and worksheet name.

Example Referencing a Range in Another Workbook (Already Opened):

CellValue = Workbooks("Workbook2").Worksheets("Sheet1").Range("A1").Value

This returns the value of cell A1 in Workbook2 on Sheet1 when called from the active workbook (Assumed to be Workbook1 for this example).

Hope this answers your question,
Leith Ross