Copy current region but don't include header row

[VBAProIWish]

Hello All,

I would like a macro that copies the current region but doesn't include the header row.

Thanks

 

[Wolfshead]

Try this
Dim rng As Range
Set rng = Range("a1").CurrentRegion
Set rng = rng.Offset(1, 0)
Set rng = rng.Resize(rng.Rows.Count - 1)
rng.Copy

 

[VBAProIWish]

Wolfshead,

What else can I say but...

PURRRFECTION!​

Thanks much
​