slow macro

Good morning All, I am not in any way good at writing a new macro but i am "okay" at manipulating several macros to do what i want, i understand the simple side of macros but after frankensteining a macro together it seems to run horribly slow with certain changes to the code ...... surprise...

Here's what's currently going on. Workbook A: Contains data, and Macro A which calls Macro B in Workbook B Workbook B: Contains no data, but contains Macro B which takes data the file which calls it, and spits it out in a text file Business requested the data and macro as in separate...

I have created an automated macro which takes vehicle crash data from a csv file and automatically creates pivot table,charts and compares it to the previous year. The code is approximately 1400 lines long and the data of the uploaded csv can be anywhere between 2 to 100 mb csv files with more...

Hello, I have a problem with a simple macro that launches a user form before saving that is running very slowly for some users. 'Code to reset the workbook view back to a default setting Application.ScreenUpdating = False Sheets("Regulatory CEs").Select...

Hi, I have just made a macro to automate a few tasks, it contains 3 pivot tables 2 of which work fine, the 3rd one errors everytime. It also slows down just before hand, doing it manually doesn't take long. I am okay at making and doing slight adjustmenst but not sure what if anything I could...

I have this bit of code that Deletes all the unnecessary rows from my data sheet. On my other workbooks that use this nearly identical code, it runs in seconds.. Sometimes 5-10 seconds if there are a few calculations/formulas. I got tasked to do the same thing for a large workbook that has a...

i am so excited that the code below works to export my conditional formatting formulas from huge spreadsheet! But it is super slow - it's looking through about 2000 cells and returning almost 200 formulas . . . but it takes almost 2 hours to run . . . I found this link about SpecialCells being...

Hi all, I am a novice at vba and attempting to import xml files from various users (each with their own sub folder in a shared drive) to a workbook template used for generating reports. To do so, I am using Excel2013 and a vba macro sub. The project name, user names, file paths etc are...

Hey all, I have a question that should be simple, but I couldn't find any information on it in searches, and other people asking similar questions seemed to just generate confusion. I'm putting together a rather large macro using Excel/VBA 2010, and I was having problems with "empty" cells not...

Hello,, I've been working on a macro to scrub a report, which comes out of a specific program, to make the data useable for basic analysis. The data is dificult to work with because the part of the record for each row is in a header row at the top of each section. The first time I wrote it, it...

Mr. Excel Community - First off, let it be known that I'm not the original author of the 10-year old code (below), but merely maintain it. After searching related threads on this site, attempts to incorporate some of the advice given were all unsuccessful at speeding up a multiple minute long...

Hi, I have a macro that I have written (below) that extracts data from several different workbooks after entering some formula and collates them together into one workbook. The data sets are huge though, with some over 200,000 rows long. It causes it to run really slowly and eventually it...

Hi, I have the following macro to copy and paste a range (never with the same lenght) but it is running slow and I receive an 'excel not responding' message. The end result is always OK. How can I speed up this macro? Thanks in advance for your help. Kind regards Al Sub aantal()...

Hi! I've about 30-50 thousand row of data from a database. To fetch these data it takes about 3 seconds. But I've to "filter" these results and it takes about 12 minutes... I don't think that this has to take that much time, if you have any suggestion please help. The columns are: - task...

I have made a macro, but I think it runs too slow. I found out which part that ran slow. My findings was that the block below used 6 sec. Does anyone have a suggestion to speed it up ?Worksheets("Oppsummering Freia").Cells(TargetRow, 3).Value = Worksheets("Registrering").Cells(6, 3).Value...

I have a code that uses excel web queries to retrieve data from a web site. The query part is optimized but the rest of the code with a lot of If statements makes it run slow. Please help. Here is the code: Sub datta() Application.DisplayAlerts = False Application.Calculation =...

Hi all, I have written the following code and am unhappy with how slow it takes to process. 'Sorts transmitter by PSIA, PSI, in H2O, deg F Sub TransmitterSort() Dim countA As Integer, countI As Integer, countO As Integer, countF As Integer Dim num_xmitters As Integer Dim...

Hi, I have created a Macro Add In that has 5 buttons and calculates atleast a 100 cells in two seperate workbooks. It also formats the worksheets. The problem I have is that after I put all the macros together in one module, it runs extremely slowly and the excel also goes into a "Not...

Hello I'm once again troubling this forum's community with a puzzle that has been driving me crazy for the past 2 days. I wrote a code that has to insert rows when certain conditions are met. The code finds the conditions, reads a number (X) in a row that meets those conditions and inserts X...

I have the below code as part of a macro, which I use to import rows of data from one workbook and put them into one of three tabs. This used to import into two tabs until the number of rows increased, so I'm assuming that one of the changes I have made is causing this code to run slowly. The...