How to fix run time error '91'

B

Bonnie

Someone at my work was doing something with Excel. Now when I try to exit I
get a message saying run time error '91'. They said they don't know what
happened. This only pops up and prevents exit when I try to hide a
spreadsheet that was hidden from before.
Does anyone have a clue?
Thanks.
 
J

JLatham

It sounds like the file has some macro(s) in it. I'd start by using
[Alt]+[F11] to open the VB Editor and then use Debug --> Compile VBA Project
and see if it points out any error in the code.

If that checks out OK, then do a search in the VB code for the name of the
sheet that you are hiding before exiting, it could be that some piece of code
is trying to reference that sheet and cannot because you have hidden it. Be
sure when you do the search that you elect to search the entire Project, not
just the current routine or module.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time 91 0
Run-time error '91' 4
Run Time Error 91 15
Run-time Error '91' 0
Run time error 91 1
Run Time Error '91' 6
Help with error 91 please 4
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1

Top