speed up macro

I'm running a bulk Goal Seek/Set using the following code over 10,000 rows. It works great but it takes about a day to run the macro! Is there any advice on how I can make it work Faster? Sub LOWEST_BULK_GOAL_SET() Dim iRow As Long For iRow = 2 To 10001 Cells(iRow, "N").GoalSeek...

Hi all, I am just looking to speed up a section of one of my macros as it seems to be lagging and I perform this macro in a high stress period of my job so it would be great to speed things up. I have to perform this macro to about 20 worksheets every 2 weeks or so. Usually only 2 of the 20...

Hi All, Synopsis = This code currently works using filters but takes ~5 seconds to loop through each item which is not very helpful when there are thousands of rows. I am looking for any ideas on how to speed up this code - my thought is that this would be possible with arrays but I am pretty...

The following code is ALOT... is there a way to simplify it? It was most likely recorded. I'm sure it slows down the Macro significantly... and it hurts my eyes :eeek::eeek: Rows("1:1").Select Selection.AutoFilter Columns("F:F").Select Selection.Cut Columns("E:E").Select...

Hello, I am trying to do some analysis on a customer's sales history to identify what types of product they are buying. I have the list of products each customer buys. I have a list of the items and the categories of those products, and my aim is to step through each customer's sales...

I'm new so if i'm doing something wrong in my explanation or not giving enough information please let me know. So I've been working on this file for some time getting it all set up thinking that adding a hyperlink would not be too difficult, however it is giving me problems. So I was hoping...

Hello, I am newbie to writing macros and still trying to get my head around dimensions. Whilst I do not understand much about them, I know that it important to define it correctly otherwise it causes the macro to run very slow. I have written my first code and it all goes fine until ''Filter 4...

Good morning, I created the following code to make calculations and then copy the results in the "Cash Flow" sheet. It takes 15 seconds but I'm sure that the code can be optimized. In step 1) formulas are applied to a range of cells in "PTF" sheet; step 2) change the date and the formula are...

Hi I have this Code, that i would like to shorten Because it's long and slow?. Some of the line is recorded with the "record macro" function. The pivottables pulls data from an OLAP Cube! Can anyone help? Sub RunAll() 'Kører følgende makro'er Call Makro1 Call Makro2 Call...

So I have created this MACRO for work, to ensure everything is getting charged right. Well I would like it to run through pretty much the entire database data for 2 years, I can not get it to last that long. I can copy the data to a separate spreadsheet and run the macro in chunks, but I would...

I am trying to do a giant find and replace in VBA. It takes hours. I have to find and replace 2 areas in each formula of each cell. The parts I am changing link to other sheets. When I change the first part (Oct to Nov) but not the second (10-31 to 11-30) I get a popup notification which I...

I have worksheet macro that takes a very long time to run. There are only 47 target cells and it takes up to 30 seconds to complete! Can anyone see how I can improve on this? Private Sub Worksheet_Change(ByVal Target As Range) ' This code checks for a change of Status in the Current Status...

Hi, I'm using Excel 2013. I would like to use some of the following code to speed up my processing. Sub test() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.CutCopyMode = False Application.DisplayStatusBar = False 'run any code...

Hi all, Can someone please take a look and hopefully figure out a way to speed up the execution of the following vba code? Thank you in advance! Code: Sub Remove_Rows() Sheets("Data").Activate Dim LRow As Long, n As Long LRow = Range("C1000000").End(xlUp).Row For n = LRow To 1 Step...

I have a workbook that has around 125 sheets and it is always changing. I use the second sheet as an Index. This macro below runs when I activate the Index Sheet. It takes around 4 seconds to run through. I use it very often and the time really adds up. Does anyone have any suggestions on...

Hi, I am using excel 2010 and am trying to automate a tedious process that takes me about half an hour. The code below already works but it takes about 5-7mins to run. Basically, I have a list of predefined numbers below that I insert into column A. Then I start at the far right of the table's...