Excel VBA Tutorial – What is Excel VBA? VBA Online Course Why do we use VBA? You can use the VBA code in Excel for example to: Create useful macros Make own functions, ie. functions that Excel doesn’t have Create Excel add-ons Use programs not related to Excel Automate your […]
vba
104 posts
1. VBA VLookUp – How to match rows? Do you want to match Excel records in VBA? VBA in Excel gives you the possibility to use the sheet functions. VBA VLookup is very important spreadsheet function. To use vLookUp function, refer to the worksheet functions using command Application.WorksheetFunction.VLookup. Let’s create two simple tables in Excel […]
Search for the last row number in the Excel table using VBA. Often in VBA we need to add another row or data record into the Excel table. To do this, it is usually necessary to find the location of the last non-empty row. To find the last completed record in the sheet, […]
1. Log VBA function – Description The Log VBA function returns value of the natural logarithm. Natural logarithm is based on e number ~ 2.72 (Euler’s number). To calculate natural logarithm value, you should use this function. For example, the value of natural logarithm from 1 is 0. 2. VBA Log […]
1. Int VBA function – Description The Int VBA function is used to round numbers that have decimal places to integers. The Int function, in comparision to the Round function, does not require additional arguments. The result will always be an integer value. An important information is that, for negative numbers, the VBA […]
1. Fix VBA function – Description The Fix VBA function is used to round numbers, that have decimal places to integers. The Fix function, in comparision to the VBA Round function, does not require entering additional arguments. The result will always be an integer value. Important information is, that for negative numbers, […]
1. Exp VBA function – Description The Exp VBA function returns exponential value of a number. To calculate exponential value, you should use this function. For example, exponential value from 1 is the Euler’s number ~ 2.72. You can learn how to use VBA EXP function from this article. 2. […]
1. Abs VBA function – Description The Abs VBA function returns the absolute value of a number. If you use this function for positive numbers it will return unchanged argument. The function used for negative numbers will return a positive value. If you want to calculate the absolute value in Excel […]