Excel error

Please see attached word document for problem statement.
Thanks.
Error-1004.docx
tesla764Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NBVCCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
0
tesla764Author Commented:
Are comments treated as an object?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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.
Error-1004-with-Code.docx
0
tesla764Author Commented:
Here's something else I tried to try to figure this problem out. See attachment.
Error-1004-using-Spread-Sheet.docx
0
Martin LissOlder 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.
0
byundtMechanical EngineerCommented:
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?
0
rytoftCommented:
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
0
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.