Hello,
can anyone help me to get just the range row 7 to 1500 instead of intire column in the code below?
can anyone help me to get just the range row 7 to 1500 instead of intire column in the code below?
Code:
Sub tstytre()
Dim j As Long
Application.ScreenUpdating = False
For j = 6 To 14853 Step 3
Columns(j).Copy
Columns(j).PasteSpecial (xlPasteValues)
Next
Application.ScreenUpdating = True
End Sub