Written a macro on my PC, works fine, no matter how many times its run. Run
on someone elses, it fails ie missing the majority of coding. Have checked
the Excel version and the Macro Security level and they are the same on both
pcs. Our pcs are set up the same and the data is in the same directories and
it picks up the majority of the coding

--
LFB

Step through the code as its executing on someone elses PC, see where
it decides to miss out the majority of code. Should give a hint what
the problem is.

hth

keith

In the VBA Editor, click tools references and look for any
references that
have missing next to them and click to check the box.

Abdul