I have a very simple macro that I created in a sheet for the week of 13 Feb
09.

Sub GoToK019()
'
' GoToK019 Macro
' Go to K019
'
Range("A472").Select
End Sub

All I want to do is go to cell A472. However, when I save the sheet to the
week of 20 Feb 09 and fire the macro, it opens up the sheet for 13 Feb 09 and
goes to that cell. I have around 70+ of these in that sheet.

How do I get the macros to carry forward each week and apply to the sheet
for the current week?

Thanks..........TC