Hi guys,

Firstly my thanks go out to those who sort out the problems of us minions. I've
learnt so much from these posts that I never thought possible - keep up the
good work guys...

I have a pretty good knowledge of Excel - years of experience with different
releases, but have never come across this situation before.
I have a a John Walkenbach termed 'megaformula' that contains ISERR, IF,
SEARCH, AND, OR, ISNA, VLOOKUP, LEFT & MID functions. Having got it to work I
opted to use copy and paste to automate it's use in a report, rather than mess
around with converting to the RC reference required by VBA.

Somehow the formula appears corrupted as the initial IF and some of the end of
the formula has vanished since running the procedure. It also contains a
couple of chinese (I can only assume) characters, which change to other chinese
characters when the cell it's contained in is activated, and some other symbols
which make the formula look like nonsense.

It doesn't appear that this is a problem as the formula still works correctly
when the procedure is run - which seems quite bizzare to me!

I'm running Excel 2000 (SP3) from Office 2000 on Windows NT 4. Using a Pentium
2 class PC with 96 meg of memory on a LAN.
Aside from telling my manager I need an updated computer does anyone have any
comments on just what is going on here?

Cheers,
JF.