Office tutorials

# Monthly Archive: December 2017

## How to use VLookUp function in VBA Excel

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 by the following pattern. Tables will […]

## Day, Month, Year, Weekday from date in Excel

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 date parts from the date. At the beginning, you should make sure that our […]

## How to find last filled row in VBA Excel

1. 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, we can use the […]

## Log VBA function. How to calculate the natural logarithm

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 function – Syntax

Number: […]

## Int VBA function – How to round negative numbers down

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 entering additional arguments. The result will always be an integer. An important information is that for negative numbers, the VBA Int function rounds a number […]

## Fix VBA function – How to round negative numbers up

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 Round function, does not require entering additional arguments. The result will always be an integer. Important information is, that for negative numbers, the VBA Fix function rounds the number […]

## Exp VBA function – How to calculate exponential value

1. Exp VBA function – Description The Exp VBA function returns an 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. 2. VBA Exp function – Syntax

Number : A numeric value used to calculate the exponential […]

## Abs VBA function – How to calculate absolute value

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 VBA, use this function. 2. VBA […]