select a range based on a name

L

Leo Demarce

I want to be able to select a range and then copy it. I did a record macro
and the result is this:

Sub CopyArea()
'' CopyArea Macro
'' Keyboard Shortcut: Ctrl+a
ActiveCell.Range("A1:N169").Select
Selection.Copy
End Sub

This works fine but what I would like to do is take it to the next level by
having the range selected based on a name. The name is PRINT_AREA and is
variable from worksheet to worksheet.
I know the answer is probably somewhere but I have searched quite a bit to
find it but no luck.
Cheers
 
Top