Davesbro
New member
- Joined
- Mar 14, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
When running this macro I get error. The macro runs all the way down to cell A1048576. I get RunTime error 1004. Application- defined or Object-defined error and highlights ActiveCell.Offset(1, 0).Range("A1").Select.
Code:
Sub Macro2()
For X = 1 To 50
ActiveCell.Rows("1:11").EntireRow.Select
Selection.Delete Shift:=xlUp
ActiveCell.Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Next X
End Sub