I have used the method of inserting a formula in a cell using '=

if one insert "=a1" in a cell (a2) the excel treats this string as a
formula and executes its.

But i a application I insert a vlookup in cells

In a2 is placed a name and in a2 is then filles with
"=vlookup(anothersheets!a:b"...)
If the formula is inserted directly in the cell excel executes it.

However when the vba program tries to insert the "=vlookup..."
statement in a2 it stops with an error because the vlookup fails
itself .
The application was suppoed to find the names which was missing but I
exected it to insert "=vlookup..." in cells a2,b2,.. and thereafter
expected to see N#A in cell a2,b2 or these cells where the name in a1
was missing.

What should I do so vba is not stopping the updating.
I have tried the om local error... which works in the program, but the
vlookup is not inserted in the a2..

Another approach is of course to let the program examine if there is a
name in the second sheet but why as the excel has the excellent
formula?
And the names in sheet two is only filled out after the the names in
sheet one is inserted.

Does anyone have a clue (maybe stop calculating while inserting - how
should one do that)?

thnkx
Anders Karbek