
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