Send Worksheet Only to Network Location

[jamesmev]

I currently have a workbook where all I need to do is have worksheet3 copied and that copy saved to a variable shared network location based on cell value.

R3 = NY

Example: :C/MyDocs/Book/NY - - -- file saved here with file name

R3= GA

C/MyDocs/Book/GA - - -- file saved here with file name

Any Help? I can save an entire workbook - but getting only sheet3 is proving a problem.

 

[Fluff]

Try

sheets("sheet3").copy

That will copy the sheet to a new workbook, which you can saveas to wherever you want