Using Data Form

R

Robert

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?

Thanks, Robert
 
R

Robert

Ron,

Thanks for the leads, however I would like to write formula / code as this
requirement is on a number of PCs and I don't want to buy the code for each
machine.

The VBA part that I can't get right is naming a range, using macro record, I
select the first cell, then holding the shift key press End and Home keys.
I then name the range. Looking at the macro this refers to R1C1 etc. etc.

Any help most welcome. Robert
 
R

Robert

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
 
T

Tom Ogilvy

If you name your range database (not with a dynamic formula definition, but
refering to the current data) and add your information using the dataform,
then the dataform will automatically extend the definition of database.
 
R

Robert

Tom,

Thanks for the tip, I never realised that the name "database" did this. I
have several lists, each on a separate sheet within a workbook and I have
found to my delight, that prefixing database with the sheet name allows for
multiple database range names.

Thanks, Robert
 
Top