Hi

I am a complete novice with vba and have a worksheet which I would lik
to save to a folder by pressing a command button. The worksheet needs t
be saved with the variable contents of cell C2 as the name. I trie
recording a simple macro which almost worked but I couldnt get it t
"save as" using the variable contents of C2 as the name. Can anybod
help me with this please?

Thanks

Nige

--
Nige
-----------------------------------------------------------------------
Nigel's Profile: http://www.excelforum.com/member.php...fo&userid=2569
View this thread: http://www.excelforum.com/showthread.php?threadid=47357