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

Insertion of rows using macros
Macros in excel download - Download - Spreadsheets
Do macros work in excel online - Guide
Function of insert key - Guide
Unlock excel vba and excel macros - Guide
Excel macro to insert rows between data - Excel Forum

1 response

Answer 1 / 1

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!

Similar discussions

Copy row and insert n times

How to add Rows automatically based on Cell Value In Excel?

Macro-Copy data from one workbook to another

Duplicate rows based on cell value

One Button To Execute Two Macros

Similar discussions

Subscribe To Our Newsletter!