Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runtime error '91' when browsing workbooks in Excel??

Status
Not open for further replies.

sgreenwood

Technical User
May 7, 2001
48
US
I'm hoping someone can help me with a VERY annoying situation that I have. I've search through all of the posts and found many references to "runtime error 91", but none in this context.

When working in Excel 2002 (Win XP Pro), I receive this error when trying to navigate through a multiple sheet workbook using ctrl-pagedown or ctrl-pageup.

I'm not running any VBA code...no macros...nothing. I'm just simply going from one worksheet to another. Usually it happens on the first page change, then when I close the error box I can move through the rest of the worksheets find until I stop and actually do something on a sheet...then when I start navigating again, the error will pop up again.

Does anyone have ANY idea what could be causing this? It is extremely annoying when you are in a hurry and trying to complete a job.

Of course to complicate things...it doesnt happen all of the time. I can go for a few days with no problem then it will start.

There is no pattern to it, no particular workbooks that set it off...it's very random.

Thanks in advance for any insight anyone might be able to offer.

Steve
 
There is a runtime error 91 in VBA when an object variable hasn't been set properly
Even if you don't have any VBA code in your workbook, you may have add-ins (Adobe Acrobat for example) that load VBA code when Excel launches.

I suggest you look for VBA code by ALT + F11 to open the VBA Editor, then CTRL + R to open the Project Explorer. In the left pane, expand everything that has a + sign next to it, then doubleclick each entry to see if anything is there. Make particular note of any projects other than your workbook--as they may contain the problematic code.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top