slow code

Below is code that I have inherited. I am not a coder. It is extremely slow and clunky from what I can tell. The number of rows in the original text file can vary. Is there a way to clean this up? This is what the original text file looks like: Sub Macro1() Dim strFile As String Dim wb...

This full code pulls data from a work website into Excel. Can be up to 55000 rows. Currently on Excel 2019 it takes forever to run. Also uses between 33%-50% of cpu. On 2016 it worked fine. I use a code already that turns off all things like calculations, events, etc. I am thinking an array...

This used to be quite fast, nothing has changed except software updates and office updates. now using business office 365 standard stuff set including Application.Calculation = xlManual Application.ScreenUpdating = False Application.EnableEvents = False Application.DisplayAlerts = False...

I've been following these forums for quite some time and finally have something to ask all the experts here. I am working on learning to code in VBA, and I've been using code that I've found around the web to build up on what I need for my worksheet. My objective is to hide rows and columns on...

Hello all, I was able to write a code that I need and works, but one part of the code works really slow when there is a lot of data. I need to work with huge lists sometimes, and when I tested the code with about 500 lines, I had to wait quite a lot of time. Could someone please help me...

Hi All, I have some code that copies data from a userform into a table. The code works but it's a little slow and clunky. I wondered if anyone could come up with a faster / more efficient code? I'm a VBA beginner and so any help would be greatly appreciated. Many thanks, Richard Private...

I found a code that I have edited to update access records via Excel (Code below). I have tested it and it works perfectly, however it takes 3 minutes to update 6 records (rows). Is there any way to fix this and make it much faster? The code searches for the primary key in an excel row, and...

Hello, I have this code behind my worksheet that is really slow and sluggish. I know there must be an easier way because the concept behind the code itself is not all too complex. The purpose of this code is to loop through column BO and paste each value 7 times. After a value is pasted, the...

My company just converted to the new office 365. I noticed that some of the VBA codes in my workbooks are executing very slow compared to the previous version :mad: I'm wondering why this is and is it a way around it? Are there new features in the new version that may affect VBA code execution...

Hi All, I wrote a macro today that creates individual files for our regional managers from a consolidated file of all regionals. The code works exactly as intended, however it's slower than I can handle. Does anyone have tips for things I can remove or alter to speed things up? Any help is...

The small section of code below is part of a much larger sub and works fine, however for some reason it takes very long to run (longer than the rest of my code). I have no idea why it is running so slowly, perhaps something to do with the 3 nested IF loops; Is there anyway to run it more...