Save only one sheet from workbook

  • Thread starter Thread starter joecrabtree
  • Start date Start date
J

joecrabtree

Hi all,

I have a workbook with lots of worksheets, but as part of my macro I
want to just save the sheet named data1 as a new file. Is there any
easy way that I can do this?

Thanks in advance,

Joseph Crabtree
 
Hi

Thats great.

I now want to be able to save all charts in the workbook as a seperate
file. All chart sheets have the name chart1, chart2 etc. Is there
anyway of modifying the codee to do this?

Thanks

Joseph
 

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

Data Selection for graph plotting 3
Delete Cell Contents IF 3
Save as problem 1
Delete sheets - all except 3 4
Date reformat and export 2
Printing Charts Macro Help 1
'Save as' problem 1
Extract and summarize data 4

Back
Top