Solved

deleted non blank rows

Posted on 2011-09-06
4
175 Views
Last Modified: 2012-05-12
I want to find all the non blank rows on the current sheet starting at row 5 and delete them.

0
Comment
Question by:vmccune
  • 2
4 Comments
 
LVL 28

Expert Comment

by:strickdd
ID: 36490976
Start here: http://excel.tips.net/T002386_Conditionally_Deleting_Rows.html

Simply modify the delete condition.
0
 
LVL 32

Expert Comment

by:Rob Henson
ID: 36494200
If you are deleting non-blank rows, why not delete all?

The blank rows that are deleted as well will be replaced with new blank rows.

Thanks
Rob H
0
 

Author Comment

by:vmccune
ID: 36494500
If I delete all, will that also delete a command button on the sheet?  How do I felete all?
0
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 36494669
If the command button is anchored above row 5 then it would stay.

How are you determining your last used row?

Assuming you can pull the row value from this as a variable, lets call it n; you could then just select rows 6 to n and use EntireRows.Delete

Alternatively, create a blank template including buttons that you can copy and paste over the relevant area. Then you could clear the whole sheet.

Thanks
Rob H
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Keyboard shortcuts for Back & Forward QAT arrows in Excel 3 56
First Blank Cell in a range 7 34
Hiding column macro 10 28
Excel copy picture into Outlook email 7 44
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now