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.


Keahlian: Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 38 ulasan ) Irvine, United States

ID Proyek: #17815006

8 freelancer menawar dengan rata-rata $27 untuk pekerjaan ini


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. Lebih banyak

$28 USD dalam 0 hari
(147 Ulasan)

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 Lebih banyak

$40 USD dalam 1 hari
(172 Ulasan)

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 Lebih banyak

$45 USD dalam 2 hari
(62 Ulasan)

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

$40 USD dalam 3 hari
(47 Ulasan)

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 Lebih banyak

$20 USD dalam 0 hari
(16 Ulasan)

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 dalam 3 hari
(0 Ulasan)

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 Lebih banyak

$15 USD dalam 1 hari
(0 Ulasan)

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 dalam 1 hari
(0 Ulasan)