How to stop a vlookup function in vba

  • Thread starter Thread starter 1234
  • Start date Start date
1

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
 
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
 
1234 said:
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.
Click to expand...

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.
 
Back
Top