Thisworkbook.SaveAs
Filename:=Thisworbook.Worksheets("Sheet1").Range(" A1").Value

If it is the active workbook, change ThisWorkbook to ActiveWorkbook in two
places

Thisworkbook refers to the workbook containing the code.

Not clear where copy and paste plays a role here.
--
Regards,
Tom Ogilvy

"Kobus" wrote in message
...
I need to write a macro that when executed, will save a file with the name
taken from the value of a specific cell in that spreadsheet. How do I do
that? Copy & paste does not work and when recording a macro is not
recorded.

Any help will be appreciated.

Thanks