calling from one worksheet sheet to source from another
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.
|