Deleting first empty row along with the next 700 rows

G

Guest

I have some data that I am trying to use the sumproduct formula on but I keep
getting the VALUE! code unless I delete the next 700 or so rows that have no
data in them. The number of rows with data changes so I can not just look at
certain number of rows. Does anyone have a way in VBA to select the first
emoty row and the next 700 rows (approx) and then delete them? Thanks in
Advance for the help.
 
B

Bob Phillips

Range("A1").SpecialCells(xlCellTypeBlanks).EntireRow.Delete


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random selection of records based on specifc value 5
Autofilter 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
Counting and deleting duplicate rows 0
Clear all rows except first two 7
Deleting decreasing data and naming rows. 5
Excel Count of Consecutive Data 0

Top