Run time error 91...pointing to where...?

D

Darin Kramer

Howdie!!

I have a rather large complex spreadsheet with many sheets, macros and
named ranges within.
FOr some unknown reason I am able to edit ANY cell in a sheet, but when
press enter I get the above error, and also a statement that says
"Object Variable or with Block Variable not set". I then dont get the
option to debug, only the option to end. How can I find out where the
error is with the VB? (There are to many Macros to step through each one
individually)

Also strange is that it doesnt happen on 3 of the sheets, but does
happen on the remaining ones.

Any ideas are very very welcomed - because currently all this work is
unusable!!!

Thanks!

D



*** Sent via Developersdex http://www.developersdex.com ***
 
M

merjet

You could at least narrow it to a particular macro by putting error
traps in each one, for example:

Sub macro1()
' Dim stmts
On Error GoTo ErrorTrap
'other VBA code
Exit Sub
ErrorTrap:
MsgBox ("Error in Macro1")
End Sub

Hth,
Merjet
 
R

RichardSchollar

Hi

I would start by checking the worksheet modules (and possibly the
ThisWorkbook module) for event code that is being activated on cell
changes (possibly calculation). If they reference other macros, then
you'll still have to step thru the macros, but it should cut down the
total to run through.

Hope this helps!

Richard
 

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

Top