Try something like this

lrow = Cells(Rows.Count, "H").End(xlUp).Row
Debug.Print lrow
You can add the code to ensure that the last row # is 4 I suspect.

"uncrox" wrote:

Hello,
I am trying to select a range of cells using a macro. The range grows each
day starting in cell B5 and ending in H* (* = the row with the last day's
worth of data). Two lines down, there is a grand total line, and two rows
from that is a footer of sorts, with date and a page number.

I found a way to get to the last used cell using a macro, however I do not
want the last cell. I want the last cell minus 4 rows.

Also, I am not sure how to select the entire range from B5 to H*. I am able
to select one cell or the other, but not the entire range.

I only dabble in VBA and have not had any program training. Any help that
anyone can provide will be greatly appreciated!

Let me know if you need more details.

Thanks in advance!