Make Excel VBA Macro Run Faster

Törölve Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Törölve Kiszállításkor fizetve

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.

Thanks!

Excel Visual Basic Visual Basic for Apps

Projektazonosító: #17815006

A projektről

8 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

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

sumon355

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. Továbbiak

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

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 Továbbiak

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

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)
5.4
paulodayto08

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 Továbbiak

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

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)
0.0
sobujkhan4044

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 Továbbiak

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

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)
0.0