How to stop a vlookup function in vba

[1234]

Hello!

I have this macro that inserts in a number of cells the function
vlookup. The problem I have is that this macro is too slow. I would
like to add an instruction to the macro to stop the vlookup function
and once the macro ends activate again this function. I´ve tried with

Application.calculation=xlmanual but it´s slow.

Thanks

 

[Don Guillett]

As ALWAYS!!, post your macro for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Hello!

I have this macro that inserts in a number of cells the function
vlookup. The problem I have is that this macro is too slow. I would
like to add an instruction to the macro to stop the vlookup function
and once the macro ends activate again this function. I´ve tried with

Application.calculation=xlmanual but it´s slow.

Thanks

 

[Alexander Wolff]

Hello!

I have this macro that inserts in a number of cells the function
vlookup. The problem I have is that this macro is too slow. I would
like to add an instruction to the macro to stop the vlookup function
and once the macro ends activate again this function. I´ve tried with

Application.calculation=xlmanual but it´s slow.

Keep one example of the vlookup-f. somewhere and copy it for recalc in the
range. Then - in the macro - do a

..Value = .Value

of the range, so it works on demand only and keeps Excel free from
calculating it after each change.