Hi,

Select I4:K2000 (or the entire range including more columns to the
left/right) and convert it to a List/Table (Ctrl+L) - this feature is
available Excel 2003 onwards. I have assumed row 4 has headers.

When you convert a range to a List, it becomes auto expanding. The caveat
here is that data should be entered in consecutive rows I.e. no row should
be left blank

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Ayo" wrote in message
...
Is there a function in excel that would allow me to replace the $2000 in
the
formular below with the last row in the column contain values.
Somthing like this, in VBA:
errorWS_lastRow = errorWS.Cells(Rows.Count, "A").End(xlUp).Row

=SUMPRODUCT((Current_MarketList!$I$5:$I$2000$T$5) *(Current_MarketList!$K$5:$K$2000="PAST
DUE"))