|Subject:||Re: Inserting blank rows between data rows (mutliple at one time)|
|Posted by:||Chip Pearson (ch…@cpearson.com)|
|Date:||Tue, 21 Oct 2003|
Try a macro like the following:
Dim RowNdx As Long
For RowNdx = 2 To LastRow * 2 Step 2
Change LastRow to the last row of your data.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"DP" <dpi…@authorizedinc.com> wrote in message
> I have a Ecel data file which includes 10,000 rows of
> data (inventory). I need to insert a blank row between
> each data row. I now how to do the insert function but
> this would only insert one blank row at a time. Help!!
Inserting blank rows between data rows (mutliple at one time) posted by DP on Tue, 21 Oct 2003