I found this code, and of course I am unable to debug it. It hangs up at the Sheets("Index").range
I am trying to have a date cell that tells me the last time the workbook was saved, and not (like it is now) where it states right now. I am apparently supposed to put the now() statement in cell A1 of whatever worksheet, and have the Macro copy and paste values only into the cell where I want the last save date. Sounds simple, and I have this piece of code, but it's like trying to write german to me. I just don't have the vocabulary.

Sub Workbook_Open()

Sheets("Index").range ("A1") 'Cell where =Now() is
Selection.Copy
Active.Sheet.range("AA85").Select ' Target Cell
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False ' PasteSpecial value only

End Sub