When I run my excel macro to try and update/caculate a sheet I get an error message. Why?

Hello,

When I try to run a macro to update a sheet in the file I get an error message stating:

Run-time error '32809':
Application-defined or object-defined error

This spreadsheet use to run fine last week but not now. I am not sure why. Could you please assist?

Thanks.
f19lAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
The sheet may be corrupted. Add a new sheet (don't use "Move or Copy") and copy everything from the old sheet to the new sheet. Run your code on the new sheet and see if that works. If it does you can delete the old sheet.
0
 
KimputerCommented:
Don't run the macro, use the Step in command, then keep pressing F8 (might take a while) to go through the code step by step. When it throws an error, post the code online, and tell us which line threw the error.
0
 
f19lAuthor Commented:
When I go through step by step and reach the line relating to calculating/updating the sheet "Cap Floor" it stops and I get the error message.

Sub Prepare()

ActiveSheet.Calculate

Sheets("Cap Floor").Calculate
   
End If

End Sub
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 
KimputerCommented:
It probably means the original sheet named "Cap Floor" has either been deleted or renamed. Can you double check the existence of this sheet?
0
 
f19lAuthor Commented:
The sheet name is correct. I even renamed the sheet and changed the macro accordingly and I still get the same problem.
0
 
KimputerCommented:
Anything on that Cap Floor sheet (added button/etc from the MS Forms)?
0
 
f19lAuthor Commented:
The only thing is a scroll bar for changing the time and a drop down box for changing the status location. Otherwise there is nothing else.
0
 
Martin LissOlder than dirtCommented:
Did you try my suggestion?
0
 
f19lAuthor Commented:
Just tried. That works now. I will go ahead and make the necessary changes. Thanks.
0
 
Martin LissOlder than dirtCommented:
This is probably the fault of the environment I'm working in but when I download your zip file I see this as its contents.

???
Could you please upload it to some file-sharing site like MediaFire or SpeedyShare and post the resulting URL?
0
 
KimputerCommented:
You tested the new sheet with those scroll bar and dropdown elements already?
0
 
KimputerCommented:
The screenshot actually shows the excel file (which means you downloaded it correctly), just rename to xlsx to get it working.
0
 
Martin LissOlder than dirtCommented:
Sorry but please ignore post ID: 40616727. I posted in the wrong thread.
0
 
f19lAuthor Commented:
The solution was to create a new tab, copy and paste the old formula and then rename.
0
 
Martin LissOlder than dirtCommented:
@Kimputer: Thanks, I just figured that out. I actually just removed the .zip extension and let Excel figure out what it was.
0
 
Martin LissOlder than dirtCommented:
@f19l: sorry for the confusion I caused but will you be closing this question?
0
 
f19lAuthor Commented:
I have accepted your post as the solution so the question should be closed now.
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
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.