I need to be able to select a range of cells where the row number is a variable, endRow.
How do I select the cells from (endRow, 1) through (endRow, 5)?
If I knew the row, I could put something like, Range("A20:E20").Select, but I don't know how to modify that when the row numbers aren't known.
Thanks in advance.
How do I select the cells from (endRow, 1) through (endRow, 5)?
If I knew the row, I could put something like, Range("A20:E20").Select, but I don't know how to modify that when the row numbers aren't known.
Thanks in advance.