Excel error

Please see attached word document for problem statement.
Who is Participating?
NBVCConnect With a Mentor Commented:
Those are errors caused by the VBA Code you have in the workbook.

If you hit the Debug button, it should go to the code and hightlight the piece of code causing the problem.
tesla764Author Commented:
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?
tesla764Author Commented:
Are comments treated as an object?
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

tesla764Author Commented:
I was able to hit Debug this time and the acutal code came up that is associated with this error. Please see new attachment.
tesla764Author Commented:
Here's something else I tried to try to figure this problem out. See attachment.
Martin LissConnect With a Mentor Older than dirtCommented:
in my profile you'll find a link roam article I wrote on debugging. Don't be put off by the VB6 in the title since almost all of applies to VBA.
byundtConnect With a Mentor Commented:
In the File...Options...Advanced menu item, make sure that the option to show "All" objects is chosen.
Display Options for This Workbook
If that doesn't fix the problem, could you please post a sample workbook that reproduces the problem and tell us which macro to run?
rytoftConnect With a Mentor Commented:
Some possible answers:

You have a comment in one of the selected cells
You have some drawn objects which don't resize with text
Your worksheet is protected

The above all gives the error
tesla764Author Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.