A number of get-arounds:

1 - use a named range for the vlookup. Redefine the named range from
macro then go
2 - use the range right down to the bottom of the spreadsheet (this i
the easiest workaround). ie to row 65536. You don't need to worry ho
many rows there are now.
3 - use code to look it up. Depends on what else you're doing.
4 - get a macro to update your vlookup formula depending on the numbe
of rows by using string manipulations to make the C3:F2000 bit.


I'm sure there's more but I use 2 unless there are other thing
happening making the other things worth doing

--
gearo
-----------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=40190