Excel VBA Examples

We can automate task to Change Text Case - Upper Lower in Excel VBA. See the following examples to know how to do this.

Description: We need are required to find Last used Row [...]

Example to show you how to find last used column with data in a Excel worksheet using VBA . It helps if you want to loop through all columns of a worksheet. We need to find last Column with data in a Worksheet Sheet if we want to loop through all columns of the worksheet using Excel VBA. For examples, my data changes every time but I need to perform same task for each column. In this situation I need to know the last column of the data every time the perform the task.

VBA hide unhide worksheets example macro macro helps when we [...]

This example will show you how to delete Worksheets from Workbook using Excel VBA. Also find code for stopping the warning message while deleting Worksheets.

Solutions: You can use SaveAs method to Save the File Example: Sub ExampleToSaveWorkbook() Workbooks.Add 'Saving the Workbook ActiveWorkbook.SaveAs "C:WorkbookName.xls" 'OR 'ActiveWorkbook.SaveAs Filename:="C:WorkbookName1.xls" End Sub

Solution: You can use the Open method to Open an Existing Workbook Example: The following code create a new workbook and save in the C drive Sub ExampleOpenAnExistingWorkbook() Workbooks.Open "C:WorkbookName.xls" 'OR 'Workbooks.Open Filename:="C:WorkbookName1.xls" End Sub

Solution: You can use Add method to create new workbook Example: The following code create a new workbook and save in the C drive Sub ExampleAddNewWorkbook() 'Adding New Workbook Workbooks.Add 'Saving the Workbook ActiveWorkbook.SaveAs "C:WorkbookName.xls" 'OR 'ActiveWorkbook.SaveAs Filename:="C:WorkbookName1.xls" End Sub

Activating a Workbook: Syntax: Workbooks("WorkBook Name").Activate Note: Workbook name will be your desire workbook name which you want to activate. Ex: If you want to activate a workbook named as “Book1” Workbooks("Book1").Activate

When we are working with workbooks and worksheets, some times we may required to access the workbook name or a worksheet name.

Solution:

Sometimes you may want to run a particular macro automatically while opening the excel file.

Example Cases:

• You may want to show a welcome message to the user
• You may want to run some sarting scripts before while opening the workbook
• You may want to fill some data while opening the workbook
• You may want to activate a particular sheet while opening the workbook
• You may want to show a user form while opening the workbook

Solution: