speed up

Hi all, I am hoping someone can help me here...I have a fairly large spreadsheet (~12MB) which I am setting up a navigation tool to "scroll" between sections. This is done by a drop down and is linked to various other parameters and all works fine. However the issue is that it is quite slow and...

Dears, Is it possible to speed up the following code? It's my first time using VBA! Public Sub Fleet() Dim Linha, ColIn, ColOut, ColUti, ColData, Contador, Model, LiFore, LinOut, LinUti, Region, Deliv, Total, Entregas, AnoDataOut, LinMS As Integer Dim LinEECAMS, LinEECFMS, Regiao, LinEEC As...

As of yet I am not good at writing efficient codes, but hopefully I'll be some day. The code below exports a lot of data from excel to a formatted word report. How can this code be faster? It takes 90 seconds on my computer! (some of the 'comments are in Norwegian..) Sub wordgenerator()...

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

Hello everyone, One of my datasheets by necessity ends up as about 25,000 rows long, but only about 40 of those rows have data in. The rest of the rows are empty. If a row has data in, there will be data in every column on that row, for example if row 2 was not empty, there would be data in A...

Hello, When I originally worked up this code, it was running in two minutes or less. The end user called me today and said that it was running really slowly. So I timed it and it was taking longer than twenty minutes, as well as slowing down all of the other applications that I was using on my...

Hello All, This will probably be an easy request for you. I am currently running a script that filters a rather large report I run to a manageable size. It runs from around 40000-50000 rows down to 2000-5000. Is there any way of speeding the script up? It takes about 20 mins to run...

Dear All, maybe a question that is hard to answer at once but i have an question about a xlsm file thay i manage, now around 15MB. there are numerous sheets (>150) in it with all kind of links within the file, to other files, and also sevaral VBA actions. Now a full recalcualtion of the file...

Hi, I am new to this forum and would really appreciate some help with a spreadsheet I am working on, I have copied the two sheets onto a new workbook and uploaded it to here: Problem.xlsm All the info on 'Sales Demand 2' gets pasted into that sheet automatically each week, Please Refer To...

I have a macro which runs the same thing 1000 times with change in the inputs. Here's the code:Sub valgen() Application.Screenupdating = False Dim RateArr(), DfArr() As Double Dim TempArr1(), TempArr2() As Variant Dim i As Integer ReDim RateArr(1 To 50, 1 To 77) ReDim DfArr(1 To 50, 1 To 154)...

Hi Folks I hope you can help. I'm running the following macro and it can take approx 40 mins to run :-( (Using on Excel 2010) Note: This may not be the most efficient code as I've recorded some elements and taken bits of the web, so bear with me. This is the code: Sub Populate_Fields()...

Hi Guys! I've created a vba macro that formates the excel sheets in some defined format. It runs quite smoothly. But then as soon as I shift the focus to some other application the performance drastically reduces. Normal run time of 30 minutes is extended to over 2 hours. The application is...

Hi, I am building a interactive spreadsheet where the user can select from 5 filters (e.g. department, team, name, etc) on certain items which will then update the table being viewed. I'm unable to use Pivot tables as it has to work between 2003/2007. I've got it working using Sumproduct but...

Hello world! In a (sometimes quite large) range, I need to "weed out" values that are less than the Integer "X" (given by the user from a User Form). Cells contain formulas originally, but most formulas already return "". Formulas need not be preserved. The following code works, but is...

Hi Folks, I am using Excel Mac 2011 and have a rather large macro that takes information from a very large global worksheet (10,000 rows) and creates approx 100 new worksheets. It's mostly nested for loops, nothing too complex. The overall performance of the Macro is fine, taking around 10...

Hi All, can anyone help me speed this code up? I run out of ideas... Sub Clear_Arrows_and_Create_Blue_Dot(ro) Dim Ro_Less_1 As Range Dim Ro_Plus_1 As Range Dim Ro_Col_1 As Range Dim Ro_Col_2 As Range Dim Ro_Col_3 As Range Dim Ro_Less_2 As Range Dim Ro_Plus_2 As Range Dim dot As String...

Could anyone suggest how I can speed up this code please? This used to work really quickly, however on my new quicker 'laptop' it takes ages. I can see in the bottom Excel bar it displaying Calculating (4 processers: x%). Which I have never seen before! Anyway.. here is the code Sub...