dear all,

I have the following problem. I have an excel file with a
lot of Vlookup's. I also run in VBA-macro in this excel
file. This macro take a long time because these vlookup's.
When I calculate my excel manually (adaption in tools-
options-calculations-manual) then my macro is much faster.
Do you have an idea how I can take this into account in my
macro? Otherwise I always have to click on F9 and run my
macro.

Thanks for any response,
Jan