Excel 2007 : Run Time Error 1004 - Document not saved

Hi,

Hope you can help?

I am getting an error message on the attached workbook "Run-time error 1004 - Document not saved", it appears random cannot spot a pattern.

The line of code highlighted is the first line in Macro 2 (invoked by CTRL-R) "ActiveWorkbook.save"

FYI - I still have this same Workbook "unresolved" in another post "Matching across Worksheets & Inserting Data", you were waiting for me to load a full workbook with all worksheets & with anonymity, which I have now done (dated 14th Dec), I also explained how the user is utilising the workbook, which I think will help ?

Many thanks in advance

Hi,

I am not sure, Jobno is a cell within a couple of the worksheets ?

FYI that line of code has been added by the Excel Forum to help me solve the other problem/post I mentioned.

I am getting the problem of Run Time Error without that coding.

Cheers