Home > Articles > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

This chapter is from the book

This chapter is from the book

Use the Columns and Rows Properties to Specify a Range

The Columns and Rows properties 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 have seen the following line used, but what is it doing?

FinalRow = Cells(Rows.Count, 1).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 useful when you need to loop through a sheet row by row—you will know exactly how many rows you need to go through.

  • + Share This
  • 🔖 Save To Your Account