optimize macro

Good Morning, I have a question about how I can optimize a macro. The macro connects three slicers. It only takes a very long time, more than two minutes before the marcro is ready. Do you have some ideas how I can speed this up? Macro: Private Sub Worksheet_PivotTableUpdate(ByVal Target As...

Hi everyone, I am new to this forum but have been reading a large number of posts recently as I am currently self teaching VBA for use at work! I currently am having an issue with a bit of code that I have created. The aim of the code is to autofilter multiple sheets depending on a cell value...

Hello guys! I have a spreadsheet with 30 sheets and I have the code bellow to. There is a way to optimize this CODE? I want a smaller code. What do the same thing for all sheets... and if error, loop or go to next. Sub CopiarPainelEntregas() Dim LR As Long Dim resposta As Integer Dim...

I used this macro to copy contents from one excel sheet to another, by comparing two columns and finding a matching cell. The problem is that this macro is taking a long time(close to three days) to complete. Can someone please help me to make things faster.(There are close to 4,00,000...

Hi guys, Can some kindly please adjust the following macro to work faster. It is currently taking 10 to 15 seconds. I am wondering if someone can help me make it faster...something like click and get.... any sort of help with me much appreciated. Sub ThirdRanked() 'Call FindAllSkills...