Excel VBA

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