Reference Range Names in Macro
I should add that the B17:K17 and b39:k39 are merged cells. Not sure if that
matters.
"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.
|