On Mon, 4 Jul 2005 07:34:01 -0700, "Angus"
wrote:

Dear experts,

it works perfect on my laptop (office 2003), but when i copy to my desktop
(office 2002), it comes with a error message "Compile error: Can't find
project or library" and highlight following line:

I get this quite frequently.

In the VBA window, go to Tools References. In the check list of
Libraries and Applications you'll find one which is probably ticked
(at the top) but described as 'Missing'. If you find one, look for a
different (earlier) version in the list and check this instead.

For instance it might say "Missing - Microsoft Excel 10.0 Object
Library", in which case find version 9.0 of the Excel Object Library.

HTH



For i = rngA.Count To 1 Step -1 ' Loop through Backup numbers





__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________