Debra,

Thank you ever so much, dynamic range is just the thing. I tried
=vlooup(A1,Customers!A:H,2) which seems to also work i.e. row number not
entered - just don't understand why this method worked.

Thanks, Robert


"Debra Dalgleish" wrote in message
...
You could create a dynamic range named 'Database'. There are
instructions he

http://www.contextures.com/xlNames01.html

Robert wrote:
Excel 2000

I have a list of customers which I add to each day and then have to
redefine
the range name i.e. extend to include the last row or rows which I
entered.

I have been using the built-in feature of Data Form and although I can
run
this by clicking a button assigned with the code
ActiveSheet.ShowDataForm, I
can't seem to figure out how to extend the range.

Do I need VBA code or a formula that expands?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html