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 ***
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 ***