Finding Next Blank Row!

[DanBanez]

Hi Guys,

I am an Excel beginner and I need help!

I have an Excel worksheet that contains 1,000 rows. I already have entered records on some of the rows. Is there a way that Excel will find the next blank row to input data?

Hope this makes sense!

Thanks in advance.

Dan Banez

 

[JackDanIce]

Try

Sub MeRemove ()

Dim i as Long
i = Range("A1000").End(xlUp).Row + 1
Range("A" & i & ":A1000").EntireRow.Delete

End Sub

 

[Trevor G]

Hi Trevor,

Here's what I was trying to do:

I have a spreadsheet that contains names, addresses, etc. of donors. The spreadsheet has 1,000 rows, although it has only 475 donors. I have 1,000 rows because I don't want to keep on adding rows when I add donors. There must be an easier way, but I am new to this.

When I query donors, and let's say the query produced only 300 names. These names will appear on my "output range" which also has 1,000 rows. Also, these names will appear on my "merge files" which also has 1,000 rows.

Since I don't want to mess up my "output range", I want to delete rows 301-1000 from my merge file, which I use to "merge" with my MS Word document that I send to these donors. If I don't delete rows 301-1000, they will merge with my MS Word document and produce 700 blank documents.

Hope this makes sense!

Thanks.

Dan Banez

I see some suggestions are coming in about deleting rows, which is really good. I think what you are trying to do is keep a unique list together so that you only send out merge documents once to donors, so would it help to identify if there names appear more than once. So I have made up a mock sheet with some details and added in a countif function that can then count how many times a donors names appear this can then assit with the next stage to only show there names once.

If i'm wrong please show some mock data for 3 sheets, the general donors list, then the other sheets. You can use Excel Jeanie to show some data as per this sample.

Excel Workbook
	A	B	C	D	E
1	Donor Name	Address	Donation	Date Added	countif
2	Mr White	123 Lower	200	02/06/2011	4
3	Mrs Williams	45 High	123	02/06/2011	4
4	Dr Blue	128 Big Hill	120	03/06/2011	3
5	Mr White	123 Lower	12	07/06/2011	4
6	Mrs Williams	45 High	45	07/06/2011	4
7	Dr Blue	128 Big Hill	900	23/06/2011	3
8	Mr White	123 Lower	200	23/06/2011	4
9	Mrs Williams	45 High	123	23/06/2011	4
10	Dr Blue	128 Big Hill	120	23/06/2011	3
11	Dr Foster	West Coattage	200	02/06/2011	1
12	Father Ted	98 Lake Road	123	23/06/2011	1
13	Miss Hallworhty	East Ridings	876	23/06/2011	1
14	Mr White	123 Lower	12,312	23/06/2011	4
15	Mrs Williams	45 High	345	23/06/2011	4
16	Mrs Gates	Lake Dart	120	23/06/2011	1
Sheet1