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
Bookmarks