Using the Columns and Rows Properties to Specify a Range

Columns and Rows refer to the columns and rows of a specified range object, which can be a worksheet or a range of cells. They return a Range object referencing the rows or columns of the specified object.

You've seen the following line used, but what is it doing? FinalRow = Range("A65536").End(xlUp).Row

This line of code finds the last row in a sheet in which column A has a value and places the row number of that Range object into FinalRow. This can be very useful when you need to loop through a sheet row by row—you'll know exactly how many rows you need to go through.

0 0

Post a comment