Range Question

[ummjay]

hi! I have a sheet which contains content in cells A1:H3, row 4 & 5 is blank, and row 6 starts a new table A6:H9.

I was trying to declare a range for A1:H last. In the event the top table 1 row, or 2, or 3, I wanted to have the range select the last row. doesnt appear to be working properly:

Header	Header	Header	Header	Header	Header	Header	Header
x	x	x	x	x	x	x	x
x	x	x	x	x	x	x	x
Header	Header			Header	Header		Header
x	x	x	x	x	x		x
x	x	x	x	x	x		x
x	x	x	x	x	x		x

Set rng = Range("A1", Range("H" & Rows.Count).End(xlUp))

how do i get it to stop in between the two table? Seems it grabs both, and ends at the end of the last table.

 

[Joe4]

thank you both!

You are welcome.
Glad we were able to help!