Hi,
i have a sheet set out with a text box. the ListFillRrange is Contacts!A3:G35
When i goto the contacts sheet and add a row at the bottom, the ListFill
Range increases to Contacts!A3:G36 which is good. however, when i insert the
row through a macro, the ListFillRange does not change. I am using a routine
that finds the next available cell on the Contacts sheet as supplied to me
through this site ( supplied he)

iRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row
ws.rows(iRow).Insert

Can something be done to insert a row but let the ListFillRange increase
automatically? this is required as i am entering alot of information through
this text box and i either have to increase the range to A3:A1000( which
gives me a amssive dropdown box) or keep updating theListFillRange.

Any help appreciated

Nigel