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