I'm only new to programming in vba but I think I may have the answer to
your query.

You should use the 'offset' function. There is an excellent example
included in Martin Green's User Form Tutorial on exceltips.com
(http://www.exceltip.com/st/Create_Us...xcel/629.html).


The relevent part of the code is about halfway down the page relating
to the ok button that copies the data put into the form onto the
spreadsheet, much the same as what you are trying to do. The contexts
and explanations are all there so I strongly recommend you to follow
the link.

Happy vba-ing

Steve Flanagan
icemonkeysteve


--
icemonkeysteve
------------------------------------------------------------------------
icemonkeysteve's Profile: http://www.excelforum.com/member.php...fo&userid=1681
View this thread: http://www.excelforum.com/showthread...hreadid=152884