Need help! Message--MEMORY COULD NOT BE READ

[mcrmike]

I need a little help with this macro. It updates the spreadsheet to the
next week and has been working fine for about 6 months,but now when I
try to run it I recieve this error;

The instruction at "0x300f8a40" referenced memory at "0x000001ac". The
memory could not be "read".

Below is the code for the macro. Any help would be appreciated.
Thanks.

Sub update()
'
' test Macro
' Macro recorded 1/7/04 by keenem
'

'
ActiveSheet.Select
ActiveSheet.Copy Before:=Sheets(1)
Range("M10:M58").Select
Selection.Copy
Range("D1058").Select
Range("D58").Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
Range("E10:K58").Select
Application.CutCopyMode = False
Selection.ClearContents
ActiveWindow.LargeScroll Down:=-4
Range("C6").Select
Selection.Copy
Range("C5").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
Application.CutCopyMode = False
Selection.Copy
ActiveSheet.Select
Application.CutCopyMode = False
ActiveSheet.Name = Range("D5").Value2
Range("E10").Select
ActiveWorkbook.save
End Sub

 

[Ron de Bruin]

Do you use Excel 97 ?

http://support.microsoft.com/default.aspx?scid=kb;en-us;177634&Product=xlw97

 

[mcrmike]

Yes I do use EXCEL 97. Thanks for responding Ron.
mcrmik