Worksheet.SaveAs

[macleanb]

Hi

(First let me apologise for this post - I am sure the answer is available, but my searches returnn soooo many threads, none of which are relevant, I have gone for the easy option and ask again).

I am using worksheet.saveas (as opposed to Workbook.saveas) expecting that it would save just the target worksheet, but it seems to behave just the same as the workbook method and all sheets are saved.

Known issue, easy workarounds? (or just me being dumb again)

 

[Gettingbetter]

Hello,

ActiveSheet.Copy 'Copies the sheet to its own workbook
ActiveWorkbook.SaveAs 'put your save as code here

Cheers
Paul

 

[macleanb]

Great - 2 lines for a work around suits me fine - but am I misunerstanding the documnentation - it soes seem to sugeest saves should be worksheet specific.

thanks