| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Data Form
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
| excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
| Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
| how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
| have 3 worksheets, 1 is a form, the other 2 data for the form-wan. | Excel Worksheet Functions | |||
![Robert[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
