Annulleret

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!

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 37 bedømmelser ) Irvine, United States

Projekt ID: #17815006

9 freelancere byder i gennemsnit $30 på dette job

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. Flere

$28 USD in 0 dage
(141 bedømmelser)
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 Flere

$40 USD på 1 dag
(170 bedømmelser)
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 Flere

$45 USD in 2 dage
(62 bedømmelser)
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 in 3 dage
(47 bedømmelser)
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 Flere

$50 USD in 3 dage
(9 bedømmelser)
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 Flere

$20 USD in 0 dage
(7 bedømmelser)
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 in 3 dage
(0 bedømmelser)
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 Flere

$15 USD på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0