speed up

Hi, in order to speed up my attached code, I would like to loop (for - next) only the last 200 rows instead to loop all the ranges AA:AA and L:L. How could I do that? Please, note that the data from Production data.xlsm is increasing every day and the code selects the ranges with an "X" in...

Hello, I'm a java backend developer (spring an so on) I know nothing about visual basic scripts in Excel, at work they gave me a task to speed up this script (ROTFL), The execution time is about 6-8 hours. I read that accessing data from a loop is a bad practice, Please help me on how to speed...

Hey everyone. Hope you're all doing well. I have a listObject table with 20k+ rows that I'm filtering with a textbox. This is the code I modified a little from extendoffice: Private Sub TextBox1_Change() 'Update by Extendoffice 2018/08/22 Dim xStr, xName As String Dim xWS As Worksheet Dim xRg...

Below is my current code. It works exactly as I need after a ton of different changes I have made. The issue is...the code takes like 30 seconds to run. It is not a dealbreaker however it is not very efficient. Any ideas on how I can speed this up?? Sub CreateInvoice()...

I have a long macro that does many things and takes a really long time to run. I'd like to speed it up, but I'm not entirely sure which part is bogging it down. I have a guess that it's one of two places, as they're the two parts of the macro that "step through" data. I've copied each below...

I have a workbook with 2 worksheets. One shows the report (Output) the other has the raw data (Raw Data). I want the user to be able to easily amend the formulas (without having to understand them) if the structure of the raw data changes, e.g. new column added. I have a header row on the...

Hey everyone. This is the first time I've written something that goes out onto a server and pulls data from multiple files. Basically I have multiple file folders, over 130, that may or may not have a sub-dir that is called "restatement reports" where inside that sub-dir multiple excel files...

Below is a code that I have for a complicated model I created. Each time I click the button to run the macro it takes roughly 30 seconds. I know it may not seem like that long of a time to wait, but when you have to click this button a lot of times it is not efficient. Can you guys look this...

Hi All, I have the following code that filters a sheet then deletes the visible rows. The problem is, it takes a very long time to run. 'Deletes "Comments:" rows with Auto Filter With ActiveSheet .AutoFilterMode = False With Range("A1", Range("A" & Rows.Count).End(xlUp))...

Any thoughts or some direction on how I can clean this up? I know it's a bit all over the place right now. Sub StatusCode() Sheet22.Visible = xlSheetVisible Sheet22.Select Dim sshh As Worksheet For Each sshh In Worksheets If sshh.Name <> "UPDATE IN PROGRESS" Then...

I first want to apologize for dumping a lot of code into here, but I have been stuck on this issue for days. I was assigned to build a planning screen wherein I could pull corresponding information regarding Sales, Production, and Inventory. As a preface to all of this, this code works for me...

Hi Everyone, I'm relatively new to using VBA so my technique at the moment is to amend code I find online to suit my needs. I know that this is not an efficient way of doing things and I suspect that I could do the same job in less time (processing time) if I used more efficient VBA. If anyone...

Here's what's currently going on. Workbook A: Contains data, and Macro A which calls Macro B in Workbook B Workbook B: Contains no data, but contains Macro B which takes data the file which calls it, and spits it out in a text file Business requested the data and macro as in separate...

Hello Everybody, I am seeking for answer about Performance of Power BI. Originally I had 2GB Access database, converted into Power BI, with some other small tables it give me 130MB PBIX. After creating the model I realized it is too slow, does not pass "3 sec" test. I did following steps: 1...

Hi, I have a worksheet with thousands of sets of data on it, being different drivers filling up with fuel. I need to take out the last fill up for every driver, but to go through and do this manually will take a very long time. Each driver has a unique identifier. Does anyone know a way where I...

I need help in speeding up my code. it takes forever to run...... Any suggestions or edits would be greatly appreciated. Sub TrimSpaces() Dim Cell As Range For Each Cell In ActiveSheet.UsedRange.Columns("L").Cells x = x + 1 Cell.Value = WorksheetFunction.Trim(Cell.Value) Next...

Hello everyone, I have a question, I have a worksheet which takes a very long time to load some values aftger using a dropdown menu created with data validation. I've includes the worksheet. I am Dutch, so I just translated some thing to let it make more sence to you guys. I've done the...

Hi community, I wrote this macro today but it's really taking way to long to run and I'm sure certain changes can be made to speed up the process. I've tried reducing the selecting and so on but sadly in vain. Would someone mind having a look below and pointing me in the right direction...

Hi guru's, I'm working on a bit of code to add a new row to a worksheet. The worksheet is for values related to electricity distribution. This particular code adds a new row to a list of equipment that is connected to a particular switchboard. When new equipment is added, the user will add...

Hey all, I found this code on the board and was able to edit it to do what I need it to do but it is realllllly slow. Any suggestions to speed things up? I have data in Columns A,B, & C. Most of Column C is blank. I want the rows where Column C is blank deleted, without deleting the entire...