software

Hi,

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

thanks--
SusieQ
------------------------------------------------------------------------
SusieQ's Profile: www.excelforum.com/member.php...oamp;userid=30818
View this thread: www.excelforum.com/showthread...hreadid=506285ActiveCell.Offset(1, 0).Select

--
Ian
--
quot;SusieQquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; How can i use VBA to move down a cell in excel?
gt;
gt; thanks
gt;
gt;
gt; --
gt; SusieQ
gt; ------------------------------------------------------------------------
gt; SusieQ's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30818
gt; View this thread: www.excelforum.com/showthread...hreadid=506285
gt;
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,quot;Aquot;).Value = 10 Then
Cells(i,quot;Aquot;).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)

quot;Ianquot; gt; wrote in message
...
gt; ActiveCell.Offset(1, 0).Select
gt;
gt; --
gt; Ian
gt; --
gt; quot;SusieQquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; How can i use VBA to move down a cell in excel?
gt; gt;
gt; gt; thanks
gt; gt;
gt; gt;
gt; gt; --
gt; gt; SusieQ
gt; gt; ------------------------------------------------------------------------
gt; gt; SusieQ's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30818
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=506285
gt; gt;
gt;
gt;