I have a macro that copies a worksheet from a workbook.. pastes value
in a new workbook.. and then saves and closes it.. but is saving i
under one name.. what I need it to do is select a cell or combinatio
of cells to use as the workbook name.. is there a way to do this..

thank you Rand

--
RANDY IN N
-----------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...fo&userid=2977
View this thread: http://www.excelforum.com/showthread.php?threadid=49558