The first blank row after the last row of data. What I've written below is
finding the first blank row in column A. I need to find the first blank row
after the last row of data in either column A or B, whichever has more data
in the row. Thanks.

"Gary''s Student" wrote:

Do you really mean the last blank row or the first blank row after the last
row of data??
--
Gary''s Student - gsnu200810


"Alex" wrote:

I have been trying to write a formula to a cell for hours and can't seem to
get it to work. I need to do the following:

Find the last blank row
set cell C2 with COUNTIF($b$2:$b$ lastblankrow,A2)
Copy the formula down from C2 until the last blank row (haven't gotten that
far yet)

Below is one of the many many ways I've tried this unsuccessfully. Can
someone help me? Thanks.

Set LastRowTemp = Cells(Rows.Count, 1).End(xlUp)(2).Row
Worksheets("DuplicateParts").Range("C2").Formula = "=CountIf(Range("B2:B
& LastRowTemp"),Range("A2"))"