Worksheet into a workbook

[ILoveStMartin]

Have a fairly large worksheet with lots of formulas which I want to put into a workbook.
Since there is no tab at the bottom of the worksheet, I do not know how to put it into a workbook but i am sure you do!!
Thanks for your help

[Logit]

.
https://www.automateexcel.com/vba/copy-worksheet/

Look through all of the examples ... the answer to your request is down the page.

[davesexcel]

Hello,
Can you explain how there is no tab at the bottom?
Could they be hidden?

sht tabs.jpg

[popipipo]

Or is the scrollbar over the full width

[protonLeah]

In the Immediate Window:
ActiveSheet.Copy

It opens a new application window named book1 or book...
then just save as and close...

[ILoveStMartin]

Thank you!!!
Feel like a dumb dumb for not looking there myself!!!!!!!!!