Find next blank row in MS Excel 2000 1

[voisey]

I have an Excel 2000 spreadsheet database that has the potential to contain 1000's of records. Using Data Form adds the first few details of the record, but because I require data validation on the remaining parts of the record I then have to 'find' the record by scrolling down to it. Is there any way that I could write a Macro to Find the next blank row in the database thus taking me to where the data form has inserted the record - or at least to the row below it.
Any help would be appreciated
PS I know it's possible because I and one of my colleagues managed to do this a few years ago but as with everything these days I put the code/macro down somewhere and now can't find or remember it

 

[theo1881]

surely just an 'end' and down arrow will take you there providing the record is always added to the bottom of the data ?

Laters, phat, headshape

 

[voisey]

Thanks And to think we never thougth of such a simple solution all those years ago - Simple when you how
Thanks again - I tried it, assigned it to a macro and it works

 

[xlbo]

There are 2 FAQs on this in the VBA forum - just as an aside, a less risky way to do this is to go to cell A65536 and use the up arrow + end

VBA code for this is

lRow = Cells(65536,1).end(xlup).row

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question