Last Updated on January 11, 2023 by token 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 […]
Yearly Archives: 2017
8 posts
Last Updated on January 11, 2023 by token 1. How to extract day, month, year, weekday and quarter from date in Excel? If you are reading this article, you would probably like to use the date and time function in Excel. Excel has built-in sheet functions to help you calculate and extract […]
Last Updated on February 8, 2023 by token 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 […]
Last Updated on January 11, 2023 by token 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 […]
Last Updated on January 11, 2023 by token 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 […]
Last Updated on January 11, 2023 by token 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 […]
Last Updated on January 11, 2023 by token 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 […]
Last Updated on January 11, 2023 by token 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 […]