Hello all, great forums!

I would like to move a sheet from a two sheet workbook, to a new workbook and save the new workbook with a file name from three cell values.

Stuie had helped me yesterday, and this is what I have so far


Private Sub copySheet()
Dim fn As String
fn = Range("C8").Value & Range("A250").Value & Range("G11").Value & ".xls"
Sheets("Sheet 1").Copy

Activeworkbook.SaveAs FileName:= _
    C:\Folderr\"& fn
End Sub
I am getting a syntax error on the last line however, any help would be greatly appreciated.