Forum Discussion
Getting Macro to loop and get the range to change each time
Hi! I hope you can help! I recorded a macro and I want to edit it to make it work for my purposes. I want the macro to copy a row of cells into a specific location. Then have the macro copy my result...
Hi Tyler Dyer
For X = 129 To 130
Range("C" & X & ":L" & X).Select
Selection.Copy
Range("B121").Select
ActiveSheet.Paste
Range("M120:R120").Select
Application.CutCopyMode = False
Selection.Copy
Range("N" & X).Select
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
Next X
Logaraj Sekar Hello could you help me as well, I need to make a loop to and add number in range A. So the sequence should be as follows, number 24 for 100 times in a column after enter 0, again 24 for 100 times, next 0 two times and again 24 for 100 times, after 0 for 3 times. So having constantly 24 for 100 times and 0 increased by 1 cell
Thank you in advance