Hi,
I'm having a problem where a macro is recorded to select a sheet, then a run-time error occurs when I run the macro.
The Error is:
Run-time error '32809':
Application-defined or object-defined error
The code is very simple:
There is a data sheet and the error occurs when selecting this sheet in the VBA code.
Please Login or Register to view this content.
Any idea why this is occurring? I'm stumped.
Just some thoughts, none of them have to be what happened.
The word select should have changed to upper case automatically so that is a concern.
1) You don't have other code where you've declared a variable called sheets? Dim Sheets as Worksheet.
2) The sheet is protected, might not make a difference but I'll throw that out there.
3) You have a Mac and I wrote code for someone and it did some weird stuff that no one with Mac experience was able to explain or help with, so maybe record the Macro again and see what happens.
4) You changed the name of the sheet.
5) You moved the macro to another workbook thinking it would open up the sheet in the workbook it originated in.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Have a read here
http://stackoverflow.com/questions/2...s-mostly-32809
If the sheet didn't exist you would probably get the "subscript out of range" error. I am guessing it has something to do with MAC. You could always try something like this:
Please Login or Register to view this content.
Thanks stnkynts - I didn't even think to add an error clause.
Also, jolivanes, very useful link.
It turns out that duplicating the tab I was working on, deleting the old one, and renaming the duplicate removed this problem also. I think sometimes Excel is just weird.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks