ExcelBanter - VBA Help needed copy a worksheet to a new workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA Help needed copy a worksheet to a new workbook (https://www.excelbanter.com/excel-programming/340478-vba-help-needed-copy-worksheet-new-workbook.html)

Neil Atkinson

VBA Help needed copy a worksheet to a new workbook

Sorry forgot to mention need this in VBA

Hi I seem to have forgot how to do this. I need to copy 1 worksheet to a
new workbook and can't find anything in Help!

Regards
Neil

*** Sent via Developersdex http://www.developersdex.com ***

Ron de Bruin

VBA Help needed copy a worksheet to a new workbook

Hi Neal

Sheets("Sheet1").Copy

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Neil Atkinson" wrote in message ...
Sorry forgot to mention need this in VBA

Hi I seem to have forgot how to do this. I need to copy 1 worksheet to a
new workbook and can't find anything in Help!

Regards
Neil

*** Sent via Developersdex http://www.developersdex.com ***

All times are GMT +1. The time now is 12:40 PM.