Zrušen

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.

Thanks!

Dovednosti: Excel, Visual Basic, Visual Basic pro aplikace

Zobrazit více: 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

O zaměstnavateli:
( 37 recenzí ) Irvine, United States

Identifikační číslo projektu: #17815006

9 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě $30

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. Další

$28 USD za 0 dní
(141 Recenzí)
6.7
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 Další

$40 USD za 1 den
(170 Recenzí)
6.5
abhinovpankaj

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 Další

$45 USD za 2 dní
(62 Recenzí)
5.6
rumapaul

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

$40 USD za 3 dní
(47 Recenzí)
5.4
dataexplorer

Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here Další

$50 USD za 3 dní
(9 Recenzí)
3.0
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 Další

$20 USD za 0 dní
(7 Recenzí)
2.8
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 za 3 dní
(0 Recenzí)
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 Další

$15 USD za 1 den
(0 Recenzí)
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 za 1 den
(0 Recenzí)
0.0