How do I find the last row containing data in a spreadsheet

A

alx613

I have a spreadsheet which can contain between 1500 and 3000 rows of data and
I want to be able to find the first blank row.

Thanks
 
R

Ron Coderre

See if one of these works for you:

Note: Commit these array formulas by holding down [Ctrl] and [Shift] when
you press [Enter]

1. The address of the first empty cell in Col_A:
=CELL("address",INDEX(A1:A65535,MATCH(TRUE,ISBLANK(A1:A65535),0)))

2. A reference to the first empty cell in Col_A:
=INDEX(A1:A65535,MATCH(TRUE,ISBLANK(A1:A65535),0))

3. The row number of the first empty cell in Col_A:
=MATCH(TRUE,ISBLANK(A1:A65535),0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
D

Duke Carey

What do you mean by 'find'? Do you mean use the row # in a formula, or
identify within a macro so you can place data there, or quickly navigate
there, or something else entirely?
 
Top