asked on

Excel error

Please see attached word document for problem statement.
Thanks.
Error-1004.docx

ASKER CERTIFIED SOLUTION

NBVC

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tesla764

ASKER

I have tried hitting the debug button and that takes me to the "After the Fact Statement". Which is "MsgBox "Error: " & Err.Description". If there was a way to go back a statement or so that would helpful.
I am using excel 2010.
This error is sporatic, hence it's hard to reproduce, but when it happens it's a show stopper.
Does anyone know what "Unable to set the Hidden property of the Range class" means?
Or what "Cannot shift objects off sheet" means?

tesla764

ASKER

Are comments treated as an object?

tesla764

ASKER

I was able to hit Debug this time and the acutal code came up that is associated with this error. Please see new attachment.
Error-1004-with-Code.docx

tesla764

ASKER

Here's something else I tried to try to figure this problem out. See attachment.
Error-1004-using-Spread-Sheet.docx

SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

rytoft

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tesla764

ASKER

I will use the information everyone has provided. I don't think there is an easy answer. I will try these suggestions and see if I can solve the problem. Thanks for all your help everybody.