speed up looping

Hello, I am trying to convert about 75 000 lines of datetime formate data (YYYY/MM/DD HH:MM:SS) into just dates (YYYY/MM/DD). The only way I have found to do this it to concatenate the YEAR(), MONTH(), DAY() parts of the data in one column into another column. However, with so many rows, this...

I tried to use method A instead of method B to speed up the loop process in function, but in the massive fx calculation did not significantly accelerate, do you know why? Dim lot_now As Long Method A: Dim lot_chk As Long lot_chk = 0 rtn_chk: If lot_now > 10 Then step = 10 Else...

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, Hoping for a way to speed up this loop. Currently this VBA transfers two values at a time (Latitude and Longitude) as inputs into a calculator on a separate worksheet which calculates the distance from the start of the road based on proximity to other points (number of different...

I have some code that looks through 10032 entries with 10020 entries so a double loop It was taking about 1 minute and 45 seconds Now for some reason it takes just under 4 minutes Is there a better/Faster way Sub FindDifference() Dim varSheetA As Variant Dim varSheetB As Variant Dim...

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

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

Hi, I am currently working on the below a macro that loops through a range and inserts a formula depending on the value of a cell outside of the range. I am running about 5 of these in the same macro and the work fine, but the time to execute is quite long (1.5min). I am looking to run this...

Anyone comment with following code so that speed up CPU calculation in looping? Application.Calculation = xlCalculationAutomatic Do while ... Do Application.Calculation = xlCalculationMaunal mid = (high + low) / 2 'bi-section Range("f" & r1) = mid 'input tick...