Skip to main content
Code Review

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link
Community Bot
Community Bot
  • 1

I tried to write a VLOOKUP in my macro but for some unknown reasons it didn't work (see my post on StackOverFlow for more infosee my post on StackOverFlow for more info.

I tried to write a VLOOKUP in my macro but for some unknown reasons it didn't work (see my post on StackOverFlow for more info.

I tried to write a VLOOKUP in my macro but for some unknown reasons it didn't work (see my post on StackOverFlow for more info.

edited title
Link
Mathieu Guindon
Mathieu Guindon
  • 75.6k
  • 18
  • 195
  • 469

Increase performance code vba - VLookup simulation: copying data from one sheet to another

Explanation of the code + Title adaptation
Source Link
edit approved May 18, 2017 at 16:41
Community Bot
edit approved May 18, 2017 at 16:41
Community Bot
  • 1

Increase performance code vba - VLookup simulation

So I decided to do a macro which achieveachieves the same result, but it takes about 20 sec to run. Any ideas on how I can improve its performance ?

What this macro is doing :

I have 2 worksheets in my workbook. Both have a column listing VINs + other info. What this macro is doing is a Vlookup from one sheet to the other one to retrieve some information when the same VIN is found.

Increase performance code vba

So I decided to do a macro which achieve the same result, but it takes about 20 sec to run. Any ideas on how I can improve its performance ?

Increase performance code vba - VLookup simulation

So I decided to do a macro which achieves the same result, but it takes about 20 sec to run. Any ideas on how I can improve its performance ?

What this macro is doing :

I have 2 worksheets in my workbook. Both have a column listing VINs + other info. What this macro is doing is a Vlookup from one sheet to the other one to retrieve some information when the same VIN is found.

Source Link
Seb
Seb
  • 121
  • 1