Override run-time error 91

[cooper1308]

Does anyone know how I can over ride the above error...

Message I get is "Object Variable or With block not set"

I want the macro to continue running as normal and not pause every time this error pops up

Thanks!

[cooper1308]

Found it...

For those with the same problem:

Please Login or Register  to view this content.

[DonkeyOte]

Using Resume Next is not a no-no but remember to reset to:

Please Login or Register  to view this content.

once you have handled your "expected" errors such that unexpected errors when encountered still generate debug.

For more info. on general approach to Error Handling see: http://www.cpearson.com/excel/ErrorHandling.htm