speed

I currently have a macro set up that loops through used rows to add a different formula to column A, B, C, D, and E. So it applies the formula to A3, then another formula to B3, etc. to E3. Then it loops and does the same to A4, B4, etc. to the end of range. Is this the fastest way, or would...

I have this line of codes however , my excel will lag and most of the time it will stop responding . Why? :( Cross Ref: How to speed up this index match function Any suggestion ? Private Sub Unsuccessful() 'Update Column S and T 'S = Active Ext ID , T = Inactive Ext ID Dim MaxRowNum As Long...

I have a very simple command button that adds 1 to a cell like a tally. Dim whiteBloodCell As Integer whiteBloodCell = Range("E10").Value + 1 Range("E10").Select ActiveCell.FormulaR1C1 = whiteBloodCell The problem I have is that lets say I see 2 white blood cells. I want to double click the...

Hi There I appreciate your insight on this. Problem starts at step 1. Then 2. …so on, excerpts below. Is a pivot table more efficient than transpose? What about the rest of the code? It keeps getting slower and never finishes in 1 hr. Task manager shows excel pegged at 13% cpu and 3.25GB...

I love this forum. I used to post here all the time and I can honestly say that the help I have gotten from people here has helped me become an OK Excel user. So I have another question and I'm wondering what you all think might be the best way to accomplish this. I have a workbook which...

Hallo Guys, I am working on analysing data for over 277 sheets with different datas. What I am searching for is to find how many times is this number which is greater or eqaul to a number and less than another number repeated. For example a number : 0<= number <4 I attached example worksheet...

Hello, My macro works but can take up to 5 minutes or more to finish up. Is there a better way to do what I have below? The table creation goes quickly it is when it goes through it to delete what it doesn't need that slows it down. I am using excel 2013, and most of my experience with vba...

I've created a Macro that will copy what's in cells and then insert that X amount of times in the cells below(Being used to copy formulas). However, the macro takes far too long to run, rendering it impractical. Could someone please assist in optimising my code so that it can run a bit quicker...

why does worksheetfunction.acos(c) take about 10 times the time of the atn( sqr(1-c*c)/c)) method :eeek::eeek:

Hi everyone, Below is a portion of code from a sub from a large worksheet table (~75000 rows A:BB columns). I currently select a range manually, then run the sub. For Each cell In rng cell.Formula = "=concatif([Material Number],[@[Material...

Hi, I know that we rather use a Sub than a Function when we do not return a value from a procedure. However, here is a case whereby all the code in a Module (even when not returning a value) has been written with Functions instead of Subs. Before changing everything (quite a task), I wonder...

Hi Forum, I am creating a macro to turn raw data into a condensed form, the rest of macro is super quick but this particular part is not, Can anyone please recommend a way to make this formula quicker...

Hi everyone, Here is a link for my spreadsheet. Hope you can download it. The query itself doesnt run too slow but the excel spreadsheet as a whole is slow. Can't scroll fast enough, make selections fast enough etc. This occurs even if it is the only file that is open...

Hi All, I'm still quite new to programming and so don't know all the tips and tricks. Here is some code I have written to summaries customer purchase information. If you can see anything I can change to speed it up it would be much appreciated... Its pretty long and taken me ages to do, but...

Dear Brilliant forum I have just received a work related task. I have little knowledge of VBA, however, I told my colleagues that this forum has the best Excel/VBA brains out there. I received a document containing our product sales and an attached macro that sorts these products (and inserts...

Hello All, I have a question regarding the speed of loading data into Power Query. Currently, I have a folder containing 10 .CSV files (each ~300MB in size). Loading this entire folder into Power Query is very convenient but after about the 2 millionth row the speed drops to the tune of ~2,000...

Hello I've been writing long, computationally expensive macros lately, and have noticed that VBA is considerably slower at certain types of computations than others. Copying/pasting, debug.prints, and Application.ScreenUpdating = True are some expensive operations that stand out to me. I was...

I have a large data set of about 375,000 rows by about 6 columns and I have a macro that does a few calculations on the dataset and appends two additional columns for each row. The calculations are pretty mild (basic division, multiplication and a sqrt function). Ultimately, the macro works as...

Good evening everyone, I have a workbook that uses a lot of array formulas (no way around this), and, after adding dynamic array formula worksheet hyperlinks to the mix, the workbook slowed down enough for me to notice the delay in calculation on my Mac Mini (quad-core i7, SSD, and 16Gb RAM)...