speed up code

I'm using below code to refer to worksheet using code name (not sure if there's another way). With a lot of worksheets the code takes a while. Is there any way to speed up? Tried "Application.ScreenUpdating = False" but doesn't make a difference. Dim my_sheet As Worksheet...

Hello masters of excel! I need advice... I have a data set or a table with about 6000 rows and about 20 columns of text and another 15 or so with some formulas splitting some strings then DATEDIF and then converting to years and months a few times over.. So.. Not a huge amount of of data but...

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

Hi Can you help with a quicker method to update the cells, I'm trying to add a value from one sheet to increase the value across a range on another sheet, whilst skipping any blank cells. Here's the code I have which works, but takes ridiculously long Sub testprices() Dim rng As Range, r As...

The following VBA UDF returns a 4-value-array using a Date value as input. Even though it is simple, if I ran for ~10'000 rows calculation time is not satisfactory (>30seconds). What am I doing wrong and how should I write the code to make it faster? ' YrMoDoy Function YrMoDoyDom(InputDate)...

Hi, I read in several post on internet about speeding up the macro based excel programs. I adopted the following procedure and as recommended added these lines in every macro. however still i feel the speed is very less although it depends upon several factors besides correct coding to which i...

All, I am having trouble with taking information from a user form and populating that information into a database. Looking for as much feedback as I can get to speed up this process to several minutes 5+ - 10+ minutes depending on the day down to seconds if possible. The bottleneck, from...