• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 91
  • Last Modified:

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.
0
f19l
Asked:
f19l
  • 7
  • 6
  • 5
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Martin LissRetired ProgrammerCommented:
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
 
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 LissRetired ProgrammerCommented:
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 LissRetired ProgrammerCommented:
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 LissRetired ProgrammerCommented:
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 LissRetired ProgrammerCommented:
@Kimputer: Thanks, I just figured that out. I actually just removed the .zip extension and let Excel figure out what it was.
0
 
Martin LissRetired ProgrammerCommented:
@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 LissRetired ProgrammerCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 7
  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now