Run Time error 9

  • Thread starter Thread starter Gerard Goodland
  • Start date Start date
G

Gerard Goodland

Hi all,
I thought I found the fault but I still can't get it to work! I am
trying to copy sheet called "inventory" to a new workbook save it with
the name of the value in cell X4 and close it and return to the
original workbook. Thanks for any help



Sheets("Inventory").Select
Sheets("Inventory").Copy
Sheets("Inventory").Name = "Inventory List"

With ActiveWorkbook
.SaveAs Filename:=Worksheets(" Inventory List ").Range("x4").Value
End With
 
Sorry Dave I don't see another reply in ths newsgroup.I am missing
something?
Thanks
 
Back
Top