Use a combination of offset and resize.

dim rng1 as range
dim rng2 as range
set rng1 = whateverrangeyouwant

with rng1
set rng2 = .resize(.rows.count-1).offset(1,0)
end with

one fewer row in rng2 than in rng1 (and the number of columns weren't specified,
so they didn't change) and then down one row.

ward376 wrote:

So it is caused by the offset. How can I avoid this? I need to leave
the header alone.

--

Dave Peterson