You could even do:
set newbk = workbooks.open(filename:="C:\temp\abc.xls")

And remember if you're going to select a range, then the worksheet has to be
selected and the workbook has to be active.

with newbk.sheets("Sheet1")
.select 'newbk must be active
set MyRngPer = .Range(.Cells(NuB, NuA), .Cells(NuC, NuA))
myrngper.select
end with


Joel wrote:

The best way to reference cell when more than one workbook is oopen is to
remember at every instruction to reference a workbook.

To reference the workbook where the macro is located use
Thisworkbook.sheets("sheet1").Range("A1").select

When you create a new workbook or open a workbook it autoimatically becomes
the active workbook so do something like this

workbooks.add
set newbk = activeworkbook

or
workbooks.open filename:="C:\temp\abc.xls"
set newbk = activeworkbook

Your code is wrong in selecting a range, you need a set statement. also you
must have a sheet reference.

newbk.sheets("Sheet1").Range(Cells(NuB, NuA), Cells(NuC, NuA)).Select
or
set MyRngPer = newbk.sheets("Sheet1").Range(Cells(NuB, NuA), Cells(NuC, NuA))
MyRngPer.select

then
"SteveDB1" wrote:

Hello.
I'm working on a macro to link two worksheets.
I've written something that appears to work, but when I went to test it I
found that it picks the range on the primary worksheet.
I need to have it select the range on the secondary worksheet.
E.g.,

MyRngPer = Range(Cells(NuB, NuA), Cells(NuC, NuA)).Select

Where the NuA, NuB, and NuC are variables I've dim'd, and input through an
input box.

How do I get the MyRngPer to select the range desired from another worksheet?

Thank you.


--

Dave Peterson