the "Procedure too large" error

[abxy]

Hello all,

Is there anyway to get around the Procedure too Large error in VBA?
Obviously looking through to see what i can code more efficiently would
help, but like the error says itself the procedure is just waaay too
large, it'd take me a very long time to basically rewrite all that code
and making sure it still is doing everything is was doing at
first...so, again, is there any way around this error?

Thanks

 

[Dave Peterson]

You could try Rob Bovey's code cleaner and Stephen Bullen's Smart indenter.

But I think any gain you get will be short lived. I think I'd bite the bullet
and shrink the code into smaller procedures (and smaller modules).

Rob Bovey's codecleaner:
http://www.appspro.com/

Stephen Bullen's Indenter:
http://www.BMSLtd.ie/Excel/Default.htm
(look for indenter97)