Finding last used Row with data in Excel Worksheet using VBA
PNRao2022-06-17T03:53:14+05:30Description: We need are required to find Last used Row [...]
LOOKUP Function in Excel – Formula Explained with Examples
PNRao2022-06-17T03:54:20+05:30LOOKUP Function in Excel - formula returns a value from a table or from an array. Learn more Formulas, Excel and VBA with examples in our free tutorials.
Change the Color of Sheet Tabs in Excel VBA
PNRao2022-06-17T03:53:28+05:30It is good idea to change the color of sheet tabs while preparing dashboards in Excel. You can use Excel VBA to automate applying Colors to Worksheet Tabs.
LOOKUP Functions in Excel to Get Required Data to Desired Range
PNRao2022-06-17T03:54:18+05:30LOOKUP Functions in Excel - formulas search for values within a table or a list and returns a value. There are three Lookup functions. Learn with Examples
COUNTIF Function in Excel
PNRao2022-06-17T03:54:35+05:30COUNTIF Function in Excel - formula counts all numbers in a range based on a given criteria. Learn more Formulas, Excel and VBA with examples explained.
SUMIF Function in Excel
PNRao2022-06-17T03:54:35+05:30SUMIF Function in Excel adds all numbers in a range based on a given criteria. Learn Formulas, Excel and VBA with examples in our free tutorials.
Hide UnHide Worksheets in Excel VBA
PNRao2022-06-17T03:53:27+05:30VBA hide unhide worksheets example macro macro helps when we [...]
Delete Worksheet in Excel VBA
PNRao2022-06-17T03:53:24+05:30This example will show you how to delete Worksheets from Workbook using Excel VBA. Also find code for stopping the warning message while deleting Worksheets.
Introduction to VBA
PNRao2022-06-17T03:55:50+05:30
VBA is a common language for all MS Office Tools (Excel, Word, PowerPoint,Outlook,Access), if you learn Excel VBA, you can able to automate any MS Office Tool , the only change is object model.
In this session:
- Introduction to VBA
- Why should I learn VBA?
- What things can we do using VBA?
- How many ways we can automate tasks using VBA?
TRIM Function in Excel
PNRao2022-06-17T03:54:16+05:30TRIM Function in Excel - formula removes unwanted spaces whether they occur between words or at the beginning or end of a string, except for single spaces between words.
CHAR Function in Excel
PNRao2022-06-17T03:54:27+05:30CHAR Function in Excel returns the last or right most character(or Characters) in a text string. Learn Formulas, Excel and VBA with examples explained.
Save Workbook Using Excel VBA to Specific Folder
PNRao2022-06-17T03:52:54+05:30Solutions: 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