Optimize excel vba code run faster

We are a startup company making silicon hardware.

Thousands of devices are fabricated on silicon wafers, and those devices need to be measured individually.

We use an Excel VBA script to generate a table from some input tables, which eventually is used for controlling a measurement robot. This vba script used to work fine with an old version of excel (5 years ago or so) but does hang or executes very slowly with new excel (2016, version 1807).

The vba runs two nested for loops over two ranges defined on two sheets of the excel file and writes out cells in another sheet.

Two example files are provided:

• one that runs ok (in some 10 secs on my thinkpad x230 i5 processor)

• one that runs very slowly or fully hangs excel

The slow-down problem of excel is related to how many iterations the loops go through, but this does not go proportionally to the number of iterations - there seems to be some threshold. The whole windows (7) operating system slows down when excel struggles with the vba code, so could it be some sort of system call problem? It also seems that excel does not consume very much of memory or processing power.

Please look at the files and the excel code within. Run the VBA code by clicking the button "Create config sheet" on the "device_listing" sheet. The difference in the files is that in the one that runs slowly or hangs, "wafermap_64groups" has a larger selection of bolded cells which means more iterations in nested for loops.

This can be an easy problem to solve for somebody with experience on VBA and it might not take more than 10 minutes for you. €100 is offered for the task.

Compétences : Excel, Visual Basic, Visual Basic pour les apps , API Windows

en voir plus : excel vba code optmization, excel vba code optimis, excel vba code log websites, excel vba code open internet explorer, inventory excel vba code, optimize excel code run faster, excel vba code check add ins, excel vba code data web page, create domain class excel vba code, ftp connection excel vba code, excel vba code pull internet data, excel vba code save web page, excel vba code updater, vba code run faster excel

Concernant l'employeur :
( 2 commentaires ) Espoo, Finland

Nº du projet : #17769838

Décerné à:


Hello, I saw your code. The slowness is happening due to multiple loops on range level. If we just ignore the loop on range level and make it on memory using an array, it will be quick. As per my understanding, I ca Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 2 jours
(15 Commentaires)

17 freelance font une offre moyenne de €136 pour ce travail


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(664 Commentaires)

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(291 Commentaires)

Hello usbcammaneger, I am waiting for your message and ready to do it now. I have opened the Macro and understood the issue.I have solution to improve its performance. I have 2.5 years experience in Exce Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(386 Commentaires)

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(88 Commentaires)

Hey Mate, I’m looking into it. Let me try using some alternative codes to make it faster but ping me to initiate the project Thanks A

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(172 Commentaires)

Hi, As you want optimization of your Excel VBA macro so that it will run faster. I will do that for you. I have expertise in VBA macros. I have many years of experience in Excel,data analysis, pivots and VBA macros Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(54 Commentaires)

masters in computer science with more then seven years of experience in Excel development and visual basics.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(53 Commentaires)

I am an Excel VBA specialist. It is best if you will award this project to me because I am proficient in creating, debugging and optimizing VBA codes.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(64 Commentaires)

Hello How are you I read your description carefully It is very interesting to me I have many good experiences in vba and algorithm I think it is good way to improve the algorithm(program shedule) So I can finish Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(3 Commentaires)

Hello. As an Algorithm expert, I can help you. This is an easy task for me and I can give you perfect result by Monday. Let me help you, please. Looking forward to hearing from you. Regards. Denis.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(2 Commentaires)

Dear Sir, I am expert in performance improvement of any kind of code. You can see my review as well. I will improve the performance and solve your hang issue as well. I am able to replicate the issue as of now and Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)

Hello As you've discovered each new version of excel simply increases in size and complexity of non calculation functions at the cost of speed and efficiency in it's main purpose of calculating numbers. This is Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(1 Évaluation)

Hello,  Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project. A brief summary of my profile as following. Over 12 years of experience in IT f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(2 Commentaires)

Hi my name is Enrique. I am developer with great experience in automation, I have found that this happens with the latest versions of VB. To avoid that slowness on your OS I think the solution is to create some python Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)

Expert with data entre, specific with Microsoft power query and the power BI Expert with data entre, specific with Microsoft power query and the power BI

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)