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")
...
Read More
OFFSET
Excel Dynamic Print Area
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...
Read More
Excel OFFSET Function for worksheet
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 ...
Read More
Excel VBA OFFSET Property for Range
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 ...
Read More