Run-time error '1004': Select method of Range class failed - MSDN ...

NewWeek Macro ' Macro to copy old info for new week ' ' Range("G5:G11").Select Selection.Copy

social.msdn.microsoft.com