This tutorial explains how to use Excel VBA usedRange Property to find the last used row and column number, and reset usedRange. You may also want to read: Excel VBA custom Function last row and last column Excel delete blank rows and blank cells before import into Access Excel VBA UsedRange Property Excel VBA UsedRange is a worksheet Property, it returns the area Range bounded by first u...

This tutorial explains how to create a custom VBA Function to find the last row and last column number in Excel worksheet. You may also want to read: Excel find the last row using Worksheet formula Excel VBA custom Function last row and last column In Excel VBA, we always need to loop through each Cell to perform some actions. For Range that you already know, you can easily use For...Ea...

This tutorial explains Excel Application Calculation Automatic and Manual. You may also want to read: Excel VBA Application Volatile Method Excel Workbook Calculation In Excel worksheet, there are three options under Workbook Calculation. Explanation of Excel Workbook Calculation Options Excel Option Description Automatic Default option. Recalculation occurs when- Ed...

This tutorial explains Excel Application Calculation Property and difference among xlCalculationAutomatic, xlCalculationManual, xlCalculationsemiautomatic Excel VBA Application Calculation Property In Excel worksheet, there are three options under Workbook Calculation. The options in Workbook Calculation uses Calculation Property in Excel VBA, which means if you execute the corresponding ...

This tutorial explains how to create a custom Excel Access MRound Function to simulate Excel spreadsheet MRound Function round to nearest multiple Excel MRound Function Excel Round Function is used to round to nearest digit, while Excel MRound Function is used to round to nearest multiple. The first time I used MRound Function is to round employee bonus to nearest $100, because we want the bonus...

This tutorial explains how to use Excel MRound Function round to nearest multiple Excel MRound Function round to nearest multiple Excel Round Function is used to round to nearest digit, while Excel MRound Function is used to round to nearest multiple. The first time I used MRound Function is to round employee bonus to nearest $100, because we don't want the bonus amount looks better. For example...

This tutorial explains how to use Excel VBA Custom Function to check if worksheet exists, and add new worksheet if worksheet doesn't exist Excel VBA Custom Function check if worksheet exists Sometimes we want to manipulate worksheet in a workbook but we are not sure if the worksheet exists. For example, we want to add a worksheet, if it already exists, skip the adding worksheet code. VBA code -...

This tutorial explains how to add new work sheets using Worksheets.Add Method in Excel VBA, or add new worksheets at the back or before specific worksheet You may also want to read: Excel VBA Worksheets.Copy Method to copy worksheet Excel VBA Worksheets.Add Method to add new worksheet Excel VBA Worksheets.Add Method is to add new worksheet in a workbook. Syntax of Excel VBA Worksheets.Add...

This tutorial explains how to loop worksheets in the same workbook, and delete worksheet, add worksheet based on worksheet name You may also want to read: Loop workbooks in folders and subfolders Excel VBA select multiple worksheets Excel VBA loop worksheets in the same workbook Loop though worksheets in the same workbook is useful when combined with If...Else statement. For example, yo...

This tutorial explains how to use VBA Excel to consolidate survey data. Excel VBA Consolidate worksheets into one worksheet Excel VBA consolidate multiple workbooks into one workbook Excel VBA combine worksheets columns into one worksheet VBA Excel Consolidate survey data It is very difficult to describe what I meant to consolidate survey data, take a look at the below picture. The g...