Hi all,
I have the following problem when setting the calculation mode to manual (xlCalculationManual).

I thought doing this would prevent VLOOKUP from being able to update the values in a cell before I reactivate auto calculation or use Range(Myrange).Calculate. Since I had also disabled screen updating I turned that on a ran through the macro one step at a time to see if it really starts calculating when I reset to xlCalculationAutomatic.

Oddly enough VLOOKUP does it's thing even with AutoCalculation disabled. Should this be happening and if not, how can I address the issue?

Thanks
Nick