Forum Discussion

Copper Contributor

Jul 31, 2017

Solved

Macro so save a sheet with info taken from a cell.

I have created a spreadsheet where the sheet 1 is a form to be filled in for Quality Control. I have created a "Save" button that will use the 'copy and move' function to create a copy of the first s...

Macros & VBA

Need Help

Logaraj Sekar
Aug 02, 2017
Hi horsteadjim,

Try this.
ActiveSheet.Name = Range("C7").Value

horsteadjim

Copper Contributor

Aug 02, 2017

Thanks for the reply. I have the copy function done already but I need to be able to rename the sheet from a cell within the sheet . This is the macro that copies the sheet.
Sub QCSave()
'
' QCSave Macro
'

'
Sheets("QC Scorecard").Select
Sheets("QC Scorecard").Copy Before:=Sheets(2)
Sheets("QC Scorecard (2)").Select
Sheets("QC Scorecard (2)").Name = "QC Scorecard (2)"
Sheets("QC Scorecard (2)").Select
Sheets("QC Scorecard (2)").Name = "(=C7)"

The last line is to rename the sheet, where I have C7 is the cell I want to copy from but it does not work.

Logaraj Sekar

Iron Contributor

Aug 02, 2017

Hi horsteadjim,

Try this.

ActiveSheet.Name = Range("C7").Value

horsteadjim
Copper Contributor
Aug 03, 2017
Thank you so much. That has worked. I am now ready to go.