Kevin B wrote:
Thanks Dave, but changing the Subtotal option for 1 to 101 will get the blank
rows, which actually what I was hoping for.

Blank rows are different from hidden rows. Any hidden rows in your
range?