PDA

View Full Version : Solved: VBA to insert blank rows (simple huh??)



joelle
10-23-2006, 11:11 AM
Hello Experts,
Hope your weekend was gorgeous (mine, a bit too warm for 2nd half of Oct).

Well, this time, I'm kinda going against the traffic -- I saw codes to delete blank rows; but the phonebook I work on has 400 names and I'd need help w/ vba code to insert one blank row below each row that already has a name and the person's info that goes across. I would like the inserted rows to have the same format like border around and Arial 9 like the existing rows.

At this age of Excel, its crazy to manually insert 400+ blank row below each existing row; thus, any help is very much appreciated!!
I attach a simple ws to better illustrate the above.

Nee

lucas
10-23-2006, 11:20 AM
See if this helps Nee....see attached

shiv jalli
10-23-2006, 11:59 AM
Updated phone.zip to exclude multiple blank rows.

Hope this helps. Shiv

lucas
10-23-2006, 12:10 PM
Rows(i).Delete

Good point Shiv jalli

joelle
10-23-2006, 01:34 PM
Hello Steve and Shiv,

Thank you so very much for the very quick turnaround and working
codes.

Best regards,
Nee