Please show us the code that you are using.
the error you give suggests a typing mistake



-----Original Message-----
Hi,
I have a macro wicht is putting in a cell a formula
vlookup(....). But Excel does not calculate it, I have a
#Name error until I click on it. I have ask excel to
calculate the cell but it doe not change anything. I am
working with Excel 2000. Is it a bug of excel 2000 or is
there a way to obtain than excel calculate it ?
Thanks for any help and happy new year.
Benjamin
.