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

If you use the SAVEAS method one of the options is FILENAME. You can
substitute a variable for filename or reference a cell value etc...

"RANDY IN NC" wrote:


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

thank you Randy


--
RANDY IN NC
------------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...o&userid=29778
View this thread: http://www.excelforum.com/showthread...hreadid=495588