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
 
You got a pretty good reply at your other post in this newsgroup.
 
Sorry Dave I don't see another reply in ths newsgroup.I am missing
something?
Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Time Error 9 1
Moving through a list 1
Compile Error 8
VB Code Help..... 1
Copying spinners for each cell in Excel 2003? 2
Couple subs need help with 2
I'm confused!!! 3
Gathering information from different worksheets in the same workbook 1

Back
Top