-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
optimize loop
-
J
match formula in for loop OPTIMISATION
Lastrow = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row For i = 3 To Lastrow Sheets("sample").Range("AM1000000").End(xlUp).Offset(1, 0).Select Selection.FormulaArray = _ "=IF(ISNUMBER(MATCH(1," & Chr(10) & " (order!R2C15:R1000000C15=RC[-24])*" & Chr(10) & "...- jaik22
- Thread
- optimisation optimize loop optimize workbook
- Replies: 3
- Forum: Excel Questions
-
There is a way to optimize this CODE? MRS EXCEL - PLS HELP!!
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...- PhBarreto
- Thread
- optimise a code optimize loop optimize macro
- Replies: 3
- Forum: Excel Questions
-
A
How to randomize a group of numbers, colors and names from a list without repeating them in the line.
I need to come up with all the combinations for the below data. I have numbers, colors and names. I need to put one number, two colors and three names in a row without repeating a name or color in each row. I would also like to not replicate the rows with the colors or names in a different...- aruen
- Thread
- optimize loop optimizer random list randomize vba
- Replies: 8
- Forum: Excel Questions
-
C
Optimizing loop: apply equations to ranges without using loop
Hello Experts, I'm am trying to optimize my vba codes and am running into a road block; I'm pretty sure there is a solution out there but I haven't been able to find it for days. I am trying to apply an equation to a ranges of cells without using a loop. I have been successful at using the...- coocooworld
- Thread
- apply equation to ranges eliminate for loop optimize loop
- Replies: 13
- Forum: Excel Questions
-
D
Avoid For Each Loop
Hi There, I have a range of about 500 cells, some of which are empty and others are numbers. I would like to divide all the numbers with VBA by 100 without affecting the empty cells. Now i have the following Loop, which takes awfully lot of time. Can I avoid these loops somehow, so that I can...- daniel22bg
- Thread
- for each loop optimize loop
- Replies: 3
- Forum: Excel Questions
