You can do this without programming, if the table has an AutoFilter
applied, and you use the built-in Data Form to add new records
To apply an AutoFilter, select a cell in the table, and choose
DataFilterAutoFilter.
To add a new record, select a cell in the table, and choose DataForm.
Click the New button, and enter the information
After you've entered the records, click the dropdown arrow in one of the
column headings, and choose (All)
heartbreakkid < wrote:
I have this table with a persons name and information on every row of
the table. After the last person on the list, i have hidden the next
200 rows. the problem is I want to use a form to add info to the table,
is there someway i can unhide the row the form puts the info on?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html