Updating active cells in vba
We will respond with a solution with in couple of days and publish here to make it available for all VBA Users.
Indentation consists of "pushing" text to the left or the right without centering it.
Here workbooks can be Active Workbook, This Workbook or a workbook assigned to an object. Workbook1 is your source workbook and Worksheet1 is your sheet to copy.
And Workbook2 is the destination sheet and sheets(1) and before key words tells Excel to copy the worksheet before the first sheet of workbook2.
In this example we will see how to save Active Sheet and specific worksheet as new excel file using VBA.
And this code should work for all the version of Microsoft Excel 2003, Excel 2007, Excel 2010, and Excel 2013.