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