How do I save a single specific sheet from a workbook

[cocosoft]

How do I save a single specific sheet from a workbook as a seperate entity without all the rest of the workbook being saved too.

Would this saved sheet be auto updated if i did further work on the sheet within the workbook and just saved the workbook in its entirety.

 

[NateO]

To what?

Man, I need to pull those broken links...

 

[Smitty]

explain how you change fname

I think that Nate covered that here:

change:
Sheets(2).[a1].Value & " " & _
Sheets(2).[a2].Value
To the appropriate sheets and ranges. Hope this helps.

What exactly were you looking to do?

Smitty