Hi, How can i use VBA to move down a cell in excel? thank
B Bob Phillips Jan 30, 2006 #3 It is rarely necessary to select in VBA, and better not to. You could always do something like For i = 1 To 100 If Cells(i,"A").Value = 10 Then Cells(i,"A").Offset(0,1).Value = Now End If Next i which does no selecting and is more efficient. -- HTH Bob Phillips (remove nothere from email address if mailing direct)
It is rarely necessary to select in VBA, and better not to. You could always do something like For i = 1 To 100 If Cells(i,"A").Value = 10 Then Cells(i,"A").Offset(0,1).Value = Now End If Next i which does no selecting and is more efficient. -- HTH Bob Phillips (remove nothere from email address if mailing direct)
