Quote Originally Posted by shortman_alan View Post
thankyou DonkeyOte, this actual made a bit of a difference! although it has made some of my other sub's not work quit as well.
will it be needed to declare calculation as ether automatic or semiautomatic at the start of the these programs?
cheers, alan

also i have been using excel 2003 and many of the machines that this document will be used on will run 2007. i was just wondering, functions such as trim() and format() are they still the same in 2007 as i have encountered a "cannot find in library" error and these are pointed to be the debugger.

cheers
Re: calculation -- if you are invoking other routines from within the same process, no - calculation is set to application level thus applies to everything -- so until it is reset to the initial calc method it will run on manual mode... you may well at certain points in your code need to force a calculation so as to ensure your variables reflect current position as the code progresses but this is still preferable to having the entire app recalculate as you alter data and/or conduct a "volatile" action (moreso if you have volatile functions in your model) ... so step through your code and determine as/when you need to enforce a calculation.

Re: 2003 to 2007 -- I'm not aware of anything that works in 2003 but not 2007 other than perhaps FileSearch (there may be others) ... there are as always a few backwards compatible issues ... on the machine that generates the error go to References in VBE and see if anything is listed as MISSING... if so post back.

Just to reiterate I didn't read through all of your code so apologies if I've missed something vital.