Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 12-25-2014, 02:00 AM
beginner beginner is offline Delete blank rows between the two rows that contain data Windows 7 32bit Delete blank rows between the two rows that contain data Office 2007
Advanced Beginner
Delete blank rows between the two rows that contain data
 
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Default

@gmayor thank you for answer
I now see that I was wrong from the start. I did not say formulas that are in range.
Therefore, some cells contain formulas that have been copied to the last row in the range. However, I want SaveAs file but before save I want delete the rows that are empty or contain this formula because the formula display zero as a result.
Can you rearrange VBA (please you see attachment file)
Thanks advance

by the way - url link to your website in your signature is incorrect.
Attached Files
File Type: xls delete-empty-rows2.xls (64.0 KB, 18 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete blank rows between the two rows that contain data Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
Delete blank rows between the two rows that contain data Grouping table rows to prevent individual rows from breaking across pages dennist77 Word 1 10-29-2013 11:39 PM
Delete blank rows between the two rows that contain data Delete Blank Rows (Cyrillic Text in Spreadsheet ) dozd Excel 1 02-22-2013 03:24 AM
Delete blank rows between the two rows that contain data Count rows and add blank rows accordingly Hoochtheseal Word VBA 1 01-29-2013 09:23 PM
Delete blank rows between the two rows that contain data 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 08:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft