software

hey guys,

i really need your help on this. i was able to do this last time but i
am totally lost right now.

I have a list of values from A1 to A600. I want to write a small macro
that would insert a row after A1, then A2 so something like this

Before
JAHSDSA
AKSHKAHD
AKJHDAKD
AKJHDAKD

AFTER
KAJHSD

AKDJHA

ASDHASD

ASHKADhelp would be greatly apprecaited. take care--
daroc
------------------------------------------------------------------------
daroc's Profile: www.excelforum.com/member.php...oamp;userid=30753
View this thread: www.excelforum.com/showthread...hreadid=519823
thxs anyways guys....i got it to work!--
daroc
------------------------------------------------------------------------
daroc's Profile: www.excelforum.com/member.php...oamp;userid=30753
View this thread: www.excelforum.com/showthread...hreadid=519823Sub InsertRows()
Dim numrow As Long
For numrow = _
Cells(Rows.Count, quot;Aquot;).End(xlUp).Row _
To 2 Step -1

Rows(numrow).Insert
Next numrow
End Sub

HTH
--
AP

quot;darocquot; gt; a écrit dans le
message de ...
gt;
gt; hey guys,
gt;
gt; i really need your help on this. i was able to do this last time but i
gt; am totally lost right now.
gt;
gt; I have a list of values from A1 to A600. I want to write a small macro
gt; that would insert a row after A1, then A2 so something like this
gt;
gt; Before
gt; JAHSDSA
gt; AKSHKAHD
gt; AKJHDAKD
gt; AKJHDAKD
gt;
gt; AFTER
gt; KAJHSD
gt;
gt; AKDJHA
gt;
gt; ASDHASD
gt;
gt; ASHKAD
gt;
gt;
gt; help would be greatly apprecaited. take care
gt;
gt;
gt; --
gt; daroc
gt; ------------------------------------------------------------------------
gt; daroc's Profile:
www.excelforum.com/member.php...oamp;userid=30753
gt; View this thread: www.excelforum.com/showthread...hreadid=519823
gt;