Macro stopped working.

The line that is highlighted is:

Please Login or Register  to view this content.

I am using a the E1 cell on each sheet to reflect dates in cell A4 as just a number. When I had

Please Login or Register  to view this content.

I always ended up with sheets printed out where A4 was empty.

I don't know if that helps at all.

With

Please Login or Register  to view this content.

I receive a Runtime error '438' Object does not support this property or method.

And still the line highlighted by the debugger is basically the same.

Please Login or Register  to view this content.

This file is moved back and forth from a sharepoint site everyday. Could that be causing corruption problems?

I did a full manual check and yes actual a lot had changed.

1) On almost all of the sheets cell A1 was "blank" instead of "empty" so instead of showing a zero in E1 it was blank
2)I found a whole bunch of sheets were the formating had been changed from General to a custom date.
3) There was one sheet where instead of E1 referencing A4 it had a REF# error.

My guess is on my days off my co-worker cleared the data by deleting the whole row and not just contents of the cells.

Everything is working now.
Thank you so much for your help.

Now if I can just figure out how to keep the empty cells empty I'll be in great shape.

I have locked most of the cells in the workbook. However I haven't locked anything that needs to have manual data entry. I was under the impression that there is no way to prevent a cell from being deleted and still have it open for data adjustment.