Reference Range Names in Macro
The named ranges are defined currently?
Audit1 refers to =Notes!$B$17:$K$17
Notel refers to =RouteSlip!$B$39:$K$39
No need to paste to a range.
Top left cell only will do.
Sheets("Notes").Range("Audit1").Copy Sheets("RouteSlip").Range("B39")
But you can use "Notel" if you want to.
Gord Dibben MS Excel MVP
On Wed, 26 Aug 2009 12:30:03 -0700, Karin
wrote:
Hi, This works:
Sheets("Notes").Range("b17:K17").Copy Sheets("RouteSlip").Range("B39:K39")
But I was hoping to use range names instead of cell references and I can't
make it work.
Range b17:K17 = Audit1
Range b39:k39 = Note1
Thank you.
|