LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Delte blank rows between different sections of data

I have 5 sections of row of information consisting of approximately 50
securities. Between each of these sections are approximately 25 rows
which contain no material in any of the columns of any of the 25 rows.
I need a macro that will delete the blank rows between each of these
segments without deleting any of the rows containing data. For point
of information the rows with the data covers 5 columns.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i divide an xl sht into 2 sections with diff placed rows Jenny Excel Discussion (Misc queries) 3 March 22nd 09 07:50 AM
Can three separate sections of rows be sorted in the same order? Jacquiemal Excel Worksheet Functions 1 February 11th 09 06:57 PM
How do I delete blank rows (rows alternate data, blank, data, etc ncochrax Excel Discussion (Misc queries) 2 June 27th 07 04:40 AM
Copy rows of data (eliminating blank rows) from fixed layout Sweepea Excel Discussion (Misc queries) 1 March 13th 07 11:05 PM
delte multiple blank rows in excel Steve Dont know how George Excel Worksheet Functions 8 October 7th 06 12:15 AM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"