Svgmassive

<div>
A small change to Skylar-Barlow's code for no credit.<br />
<br />
When done this way <b>Dim tBook,sBook as Workbook</b>, tBook is defined as a Variant and not as a Workbook, and since Variants are the slowest type of variable, a very small, probably unnoticeable, amount will be added to the time the code needs to execute, so do <b>Dim tBook As Workbook ,sBook as Workbook</b> instead.
</div>


A small change to Skylar-Barlow's code for no credit.

When done this way Dim tBook,sBook as Workbook, tBook is defined as a Variant and not as a Workbook, and since Variants are the slowest type of variable, a very small, probably unnoticeable, amount will be added to the time the code needs to execute, so do Dim tBook As Workbook ,sBook as Workbook instead.

<div>
i used the autofilter copy so rob and skylar i will spit the point
</div>


i used the autofilter copy so rob and skylar i will spit the point

<div>
<div class="content wysiwyg-content">
I need a function that will create a new workbook from the visible cells only.<br />
thanks
</div>
</div>


I need a function that will create a new workbook from the visible cells only.
thanks

Visible cells to a New workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.