Make Excel VBA Macro Run Faster

Hi found a function [login to view URL]

It works perfectly, but is very slow as it steps through each cell one at a time.

e.g. to covert a single 1000 character cell, it takes about 10 seconds on my fast computer.

I found a fix I think, but I need a VBA expert to do it for me (or find a fix that will): [login to view URL]

I am including the excel file with the code. You will see the macro operating slowly, but correctly in cell F2 and F3.


Készségek: Excel, Visual Basic, Visual Basic for Apps

Bővebben: perl scripts run faster, optimize excel code run faster, can vba script run outside excel, how to speed up macros in excel 2010, excel 2013 macro very slow, how to make vba run faster, excel 2016 macros running slow, excel slow after running macro, excel macro slowing down after each use, excel macro running slow, how to make macro run faster, vba macro run automatically word, macro run external application excel, macro run upon opening word document, excel vba automatically run script, create excel macro run powershell script, delphi excel macro run, jave access excel spread sheet run macro, make website run faster, vba code run faster excel

A munkaadóról:
( 38 értékelés ) Irvine, United States

Projektazonosító: #17815006

8 szabadúszó tett átlagosan $27 árajánlatot erre a munkára


Hello, As an expert in excel VBA, i am very much interested to optimize the code. I am checking the code and current execution time and the link you shared. Will discuss with you if you are interested in my bid. Több

$28 USD 0 napon belül
(147 vélemény)

Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. P Több

$40 USD 1 napon belül
(172 vélemény)

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Több

$45 USD 2 napon belül
(62 vélemény)

Hello Sir I have gone through the project requirement Kindly contact me once Having experience in VBA coding Thank You

$40 USD 3 napon belül
(47 vélemény)

Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work in small period of time, but need to know the full requirements to assess how long would Több

$20 USD 0 napon belül
(16 vélemény)

Hi, i am a engineering undergraduate. i am having a small group of my friends. i think we can definitely complete your task in a given period. we need money for our studies and good review. thank you

$13 USD 3 napon belül
(0 vélemény)

hello sir, good day,myself sobuj khan,i read your project description care fully,i am data entry expert and lead generation expert,i really want to do this project,i can do this project at cheep rate,for more discus s Több

$15 USD 1 napon belül
(0 vélemény)

I think i am the Right person who can take responsibility for you project and can complete it according to your REQUIREMENTS, As i got all the skills that you need for this project.

$15 USD 1 napon belül
(0 vélemény)