speed

Hi, I have the following code for find and replace: Sub CSERÉL() Dim X As Long, WS As Worksheet, Words As Variant, Replacements As Variant Words = Array("2017.08") Replacements = Array("2017.09") For Each WS In ActiveWindow.SelectedSheets For X = LBound(Words) To UBound(Words)...

Changes were made this weekend to speed up the forum. If you notice any unusual slowness (usual would be queries, unusual would be posting or opening a thread) or errors, please post here, with as much error information as possible. For speed issues, please note, if possible, the number of users...

Hello, Using 2010 Excel, I have 192k rows and 6.5m filled cells of data that I need to be able to match certain criteria to and pull the matching rows from the data sheet into another sheet. It also needs to be as fast as possible (no looping?). My research took me to these posts regarding...

Hi, I have the code below which works fine but am looking to see if anyone knows of a way to speed it up - it currently takes around 12 secs to run. You will notice that the ranges all have the same row numbers. Many thanks. Application.ScreenUpdating = False For Each c In...

Hi All, I have a formula that works perfectly well, but it's a little sluggish: ={SUM(IF(MONTH('Entries'!$C$2:$C$50000)=MONTH(L$34),IF(YEAR('Entries'!$C$2:$C$50000)=YEAR(L$34),'Entries'!$H$2:$H$50000,0),0))} I thought i might use EOMONTH to speed up rather than evaluating the date twice...

Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. New to VBA coding so having difficulty in making this work... below shows the code I have thus far but when run, it only extracts the first set of data but does not move onto...

Hi, I need to calculate latitude and longitude for given speed and heading. First value of latitude and longitude is provide rest of the values need to be calculated for given other parameters such as speed and heading d1=speeds(1)*stept1; d2=speeds(2)*stept2...

Hello, I got the code below. With 24000 rows it takes 42 seconds to execute. Is it possible to do it in another way to speed up? Kalle Private Sub CommandButton5_Click() Dim rng1 As Range Dim strSearch As String Dim V As Variant Dim shRow As Long NotCorrect = 0...

Hello, I am trying to preform a duplicate row check on a data set spanning over 6 columns and approx. 250,000 rows of data. What I am trying to find is the more efficient way to highlight any duplicate rows. The code I have at the moment currently take around 45 minutes plus and I can’t help...

Hello, I have a workbook I update every month, and currently I have just been using control find replace to update. However, this takes me 10+ minutes for each of 5 tabs, as there are thousands of cells it needs to replace that is linking to a previous month's file. Is there a way to quickly...

Hello I work with very large data sets in excel. Part of the process is using vlookups to pull information from our system about existing product min/maxes and compare it to planned min/maxes. The files I am working often have 34k-70k lines of data (that is all needed). Is there a better pull...

Hello all, I am having an issue! I have a 3D sonic anemometer, and this is the first time I deal with it. I did a small experiment to collect some data. The output was U, V, and W for every 0.3 second. I have a huge excel sheet of data, and I don't know how to measure wind speed and direction...

This code works but it takes a few minutes to complete depending on the number of worksheets in the original workbook (see link below). The time is not of great concern; however, my laptop at times slow down considerably or freezes altogether during execution of the code. Is there a way to...

Having trouble with speed of a vba script for importing data into an excel table. Hoping someone here can help. As the comments in my code state this script takes about 8 seconds to import 100 rows of data. I would love to bring it down to fractions of a second. Sub ImportMyData()...

Hi, I've got really good code from AlphaFrog below. Every file this tries to loop through gives me the same two prompts each time: 1. This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest date. Otherwise, you...

Dear all I have dsum formula =DSUM(for_dsum,'raw data'!L4,'manual entries'!O2:P3) and sumifs formula = =SUMIFS('sales history'!quantity,nature,"@",month_year,MONTH(C$2)&YEAR(C$2)) total no of raws is 11,000 can anybody tell me which formula works faster thank you Regards,

When I try to run below code in a loop, or several times in a row (i.e. Call RunAllMergeSheets, Call RunAllMergeSheets etc) the time it takes to run the macro increases exponentially. - Is there any way to speed this up? What's causing the biggest slowdown in the speed (minus the increase in...

I'm stumped on some code I'm running. I have two workbooks that are for all intents and purposes identical. I have a macro I am running in both of them that has identical code. In one workbook it takes six seconds, in the other 1 minute and 20 seconds. Does anyone have any general tips or...

I have a workbook where there are various groups of cells where users enter values. I have code which translates that worksheet into a nice clean data table. Essentially the code loops through the defined ranges and checks every cell to see if there is a value > 0. If there is a positive...

Hi all, I've got a macro which deletes rows which do not have a cell equal to "kilogram", while also inserting a blank row after each instance of "99999". To do this I am using multiple loops, and as such running this macro takes quite a bit of time. Is there any way I can clean up my code to...