Run Time error 9

[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

 

[Dave Peterson]

You got a pretty good reply at your other post in this newsgroup.

 

[Gerard Goodland]

Sorry Dave I don't see another reply in ths newsgroup.I am missing
something?
Thanks

 

[Norman Jones]

Hi Gerard,

See:

http://tinyurl.com/5ce9y