Move down cell
 

Hi,

How can i use VBA to move down a cell in excel?

thanks


--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile: http://www.excelforum.com/member.php...o&userid=30818
View this thread: http://www.excelforum.com/showthread...hreadid=506285

Move down cell
 

ActiveCell.Offset(1, 0).Select

--
Ian
--
"SusieQ" wrote in
message ...

Hi,

How can i use VBA to move down a cell in excel?

thanks


--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile:
http://www.excelforum.com/member.php...o&userid=30818
View this thread: http://www.excelforum.com/showthread...hreadid=506285

Move down cell
 

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)

"Ian" wrote in message
...
ActiveCell.Offset(1, 0).Select

--
Ian
--
"SusieQ" wrote in
message ...

Hi,

How can i use VBA to move down a cell in excel?

thanks


--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile:
http://www.excelforum.com/member.php...o&userid=30818
View this thread:
http://www.excelforum.com/showthread...hreadid=506285