Woops, I met 2000 lines. But 81000 Lines??? your shlong must reach to the
floor!


"RB Smissaert" wrote in message
...
200 lines, very complex?
I have an application with 3 .xla files and a number of dll files.
Main .xla file has over 81000 lines of code.
Have run this now in 2007 and no problem at all, but haven't looked
at pivots yet.

RBS

"Allan P. London, CPA" wrote in message
...
I attempted to run a very complex Excel App (over 200 lines of Code) on
Excel 2007 Beta. I noted two problems immediately:



1. The VBA code for Past-Special-Add is flakey so consolidated results
don't balance?

2. The code that refreshes pivot tables does not work?



As soon as I fix these problems, I am sure other problems will turn up.
Is there a place where 2007 problems are discussed?



Thanks,



Allan P. London, CPA