Hi Ron

Thanks for replying.........I cant test the vba program you kindly
wrote for me untill I go back to work tomorrow.....however looking at
it (and what do I know!)....I cant see any reference to cell C2.....As
the sheet is like a template and will be used over and over again I
need it to be saved to a seperate file with the variable contents of C2
as the file name...........Just for the record I have another command
button on the same sheet which when pressed clears the "template" of
all added information and returns it to the basic form again ready for
new data entry..........(somebody else on here told me how to do
that!)......I hope you can get some idea of what Im trying to achieve
from the above description and do you think your prgram suggestion will
work ok?

Regards

Nigel


--
Nigel
------------------------------------------------------------------------
Nigel's Profile: http://www.excelforum.com/member.php...o&userid=25696
View this thread: http://www.excelforum.com/showthread...hreadid=473579