grab values from a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to put together some VBA that will do this.

1) Copy the cell values of a named range from another workbook to this
workbook, starting in current cell.

2) I will then duplicate that code to create a second macro, but in the
second macro I'm going to replace the value in column m with a formula. I
think I can figure that part out if I can get the first chunk. Any help
appreciated.

thx - Russ
 
Sub Macro1()
Workbooks("OtherWb").Sheets("Sheet1").Range("MyRange").Copy _
ActiveCell
End Sub

Hth,
Merjet
 
Merjet,

Must the workbook be open? I'm using

Sub GetPlaybookData()
Workbooks("H:\IT Process Engineering Artifacts\Practice Area\CF
Playbook.xls").Sheets("Project Staffing").Range("Desired_Staffing2").Copy
ActiveCell
End Sub

and I keep getting subscript out of range. I googled that and it looks like
that would likely mean that something isn't there that I think is there.
This file, worksheet and range definitely exist. Any ideas? -thx
 
Yes, the workbook must be open for the code I gave you to work. If you
want to do it with a closed workbook, search this group for "closed
workbook".

Merjet
 
Back
Top