easy way to find bottom row in worksheet data?

[riwiseuse]

I'm wondering if there is an easy function for identifying the bottom of data. excel well scroll to an infinite number of cell rows or records but it seems to kind of know what the limits of records are as being used on the current worksheet.

i can't just use ISBLANK in a given column on these records because some fields are missing. and there are an empty row or two internally to the records so I'd end up having to do a lot of IF checking that all the cells in a row were empty int he columns that have data and the there was nothing below them for half a dozen records to really know that i was at the end.

I need something like BOTTOM or LAST.RECORD or something that i can't find . . .

anybody got the magic bullet.

thanks

[pjwhitfield]

LastRow = Cells(Rows.Count, "A").End(xlUp).Row

Where A is the column you know has data in

[riwiseuse]

PS - i used to know how to mark stuff SOLVED. is there just a glyphic toggle that i don't recognize these days or . . .

[riwiseuse]

thanks for that. I'm kind of a conscientious objector to VBA. I spent all that time learning XLM and then they kick me overboard. At least it still runs on 2011 for the Mac. and my old XLM macro.fun documentation for XLM 4.0 came through:

SELECT.LAST.CELL()

brian