Bob. I do not understand now that will help redifine the range. More o
what I am doing:

I am using code to open the form to add data. When the form closes,
want to redifine the range to inlcude the new data (just like using th
range name database). I am using two to three forms to enter data int
different tables

--
Richard

-----------------------------------------------------------------------
Richard m's Profile: http://www.excelforum.com/member.php...nfo&userid=260
View this thread: http://www.excelforum.com/showthread.php?threadid=51984