This code moves down column A to the end of the list:
Sub Test1() Dim x As Integer ' Set numrows = number of rows of data. NumRows = Range("A2", Range("A2").End(xldown)).Rows.Count ' Select cell a1. Range("A2").Select ' Establish "For" loop to loop "numrows" number of times. For x = 1 To NumRows ' Insert your code here. ' Selects cell down 1 row from active cell. ActiveCell.Offset(1, 0).Select Next End Sub
No comments:
Post a Comment