slow

Hi all, find below a code for coloring cell based on the adjacent cell value. This code is running very slow, especially if the data in selection is more than 2000. Please help. Private Sub CommandButton2_Click() Dim c As Range firstVal = 0 cellColor = 0 With Selection...

Hi, I have the following code that checks for a condition in the range, and ifit is a ‘1’ then it select some cells and formats them (by changing theinterior colour, interior.ThemeColor and Font.ThemeColor). The problem is that, as the program loops through so many cells, itselects many –...

Hi, Sometimes when I toggle from other applications into Excel, it takes a couple seconds for Excel to respond to the initial click. This only happens on the initial click into Excel. After that it works fine. This issue isn't limited to one file, either. It seems to happen to all of the...

Good morning All, I am not in any way good at writing a new macro but i am "okay" at manipulating several macros to do what i want, i understand the simple side of macros but after frankensteining a macro together it seems to run horribly slow with certain changes to the code ...... surprise...

Dear All, I'm working a quite big process with a userform with 8/10 buttons doing different things on a sheet. The file il 1400 kb big and it used to be normally fast. Some weeks ago all the processes suddently slowed down but I can't understand why and i don't know where to start to find out...

Hi Everyone, I have this macro that is quite long as you can see and does a number of different things, however, although it works it is very slow and I was woundering if anyone could suggest parts that could be edited to improve its speed? any help and suggestions will be appreciated and I...

I have a looping macro to print a page for each filtered item in a pivot table. What I'd like to do is add the sleep command to have it wait for about 2 to 3 seconds before it goes to the next item. Sub PrintPivotPages()'prints a copy of pivot table for 'each item in page field 'assumes one...

Hi, I have an Excel worksheet that has to do an index/match to look up data from another sheet. It has 14 rows and ~8,000 columns -- each with an index/match. So, as you can imagine, the file is huge (60 MB) and too slow to be usable. I'm thinking I could instead have a macro do the lookups...

I have a workbook with lots of formulas and sheets. It is updated weekly and the data grows irregularly with every update. As of right now I have my formulas referencing entire columns in order to capture all new data. This is starting to catch up with me, as the processing time is detracting...

Hi there, I'm relatively new to VBA, although have been picking it up quickly in the past month or so. I have been working on a spreadsheet that completes several actions dependant on certain cell's values in the spreadsheet. The spreadsheet essentially is used to analyse a time sheet; colour...

Hi Everyone, I have a situation where I currently have 25 stores all with exactly the same very complex document. now the problems I face are that if I need to update a macro for example, I have to go into every copy and change it. So I was wondering if it would slow the document down if I...

Hi I have a large (>20mb) Excel file (xlsb) that opens and saves reasonably quickly, but takes up to a minute to close (even without saving) if there are other (non-linked) workbooks open at the same time. If no other workbooks are open, it closes almost instantly. Has anyone ever experienced...

I have a macro that creates multiple charts. The data is time sequenced and I would like to slow down the macro so the changes in the charts can be seen as they are made. Sort of like a movie effect. Can this be done?

Hi folks! The following VBA code is applied to a single worksheet, it triggers and email send (via Outlook) when a cell in a row becomes "Overdue". It actually works fine, however I've noticed upon opening the workbook it takes an AGE to calculate and then allow me to modify the worksheets...

Hello, I have a problem with my VBA code, it takes a lot of time to execute even if the code seems quite simple... :confused: For the context, I have a very large sheet with a pattern of 3 columns (Month, Year and Value) and I want to delete the three of them if the value cell is empty. It has...

Hi all, I have an formula today that I use to calculate the FY week number. The problem is that with my table, 80k+ rows and expanding, this is a very slow process. Does anyone have an suggestion on how to speed up this formula? =WEEKNUM(A2,1)-26+IF(MONTH(A2)<7,52,0)

Hey, Merry Christmas. I have large excel file with formulas that goes very slow on updating. Kindly what to do making it goes faster???? Cheers, Mawama

I have a macro which runs about 6 functions. Besides the last function, each function takes less then 1 second to complete. The last function however is taking over 30 seconds to complete (I timed them all). When I put a 'Stop' at the 6 function and then hit play again, the 6 function will then...

Hi Guys, I have been an admirer of this forum since a long time and it has helped me a quite a lot but this time i had to post my query as i was getting nowhere through Google searches. So, this table below is an example of my data set: <colgroup><col width="64" span="5" style="width:48pt">...

Hey guys, I'm new here and have a beginners questions. I have created a userform for data entry (code below). The form takes approximately 12 seconds to transfer the data to the spreadsheet. I have tried the recommendations in the following page...