Excel VBA custom Function last row and last column

Posted on March 12, 2015March 23, 2017 by Wyman W

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...Each Loop to loop through each Cell for a specified Range as below For Each rng in Range("A1:C10") ...

Excel Dynamic Print Area

Posted on January 9, 2015January 3, 2016 by Wyman W

This Excel tutorial explains how to set dynamic print area. You may also want to read: Excel dynamic Data Validation list Excel dynamic data range Excel graph dynamic data range Excel Print Area Print Area is a function to define the worksheet Range you want to print. To set a Print Area, select a Range, say A1:B6, then click on Set Print Area Click on FORMULA tab > Name Manager You will find Range A1:B6 is named as Print_Area, which is the reserved name f...

Excel OFFSET Function for worksheet

Posted on December 23, 2014January 9, 2015 by Wyman W

What is Excel OFFSET Function? Excel OFFSET Function returns the Range object which is number of rows and columns away from a specific range. You can specify to shift up, down, left or right from a cell. For example, if column A contains employee ID, and column B contains employee name, you can find the employee name in B2 by shifting A2 to the right. (shift 1 column to the right and shift 0 row). The advantage of using OFFSET property is that even when the actual column change, you don't ...

Excel VBA OFFSET Property for Range

Posted on December 23, 2014February 26, 2017 by Wyman W

This Excel VBA tutorial explains how to use Excel VBA OFFSET property, and explain difference between VBA OFFSET Property and worksheet OFFSET Function. Excel VBA OFFSET Property Excel VBA OFFSET property returns the Range object which is number of rows and columns away from a specific range. You can specify to shift up, down, left or right from a cell. For example, if column A contains employee ID, and column B contains employee name, you can find the employee name in B2 by shifting A2 to ...