Insertion of rows using macros

Closed
Chaitanya.vvishnu Posts 1 Registration date Thursday December 4, 2008 Status Member Last seen December 8, 2008 - Dec 8, 2008 at 12:37 AM
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 - Dec 8, 2008 at 02:23 AM
Hello,
hi

I working on excel sheet of 2000 rows of various departments. There is empty cell after each department ends.

I wanna insert more new rows in this column, whennever there is a empty cell (using macros).

Pls suggest me on this
Related:

1 response

TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 74
Dec 8, 2008 at 02:23 AM
Well I suggest you use this resource which has alot of useful information related to macros in Excel. This link will take you directly to the portion you are interested in.

http://dmcritchie.mvps.org/excel/insrtrow.htm

Good Luck!
0