Delete blank rows between the two rows that contain data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Delete blank rows between the two rows that contain data

FAQ

Mark Forums Read

Thread Tools

Display Modes

12-24-2014, 05:25 AM

beginner

Windows 7 32bit Delete blank rows between the two rows that contain data

Office 2007

Advanced Beginner

Join Date: Sep 2011

Location: Europe

Posts: 45

Delete blank rows between the two rows that contain data

This file in the future will be read-only or as a template.
I need VBA to when saving files (SaveAs) but before saving the macro should delete all blank rows between the two rows containing data.

Can anybody help me?
Please see attach

Attached Files

delete-empty-rows.xls (31.5 KB, 16 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Delete Blank Rows (Cyrillic Text in Spreadsheet )	dozd	Excel	1	02-22-2013 03:24 AM
Count rows and add blank rows accordingly	Hoochtheseal	Word VBA	1	01-29-2013 09:23 PM
How to remove blank rows from a specified range?	Learner7	Excel	1	04-19-2011 02:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:29 PM.