how use current region to clear cells without clear headers ?

[abdo meghari]

Hi guys,
I'm struggle to clear data before copy from another sheet start from row 2 but the problem is clear the header in row 1
I use this

 ws2.Cells(2, 5).CurrentRegion.ClearContents

ws2 will be sheet reference is sheet1
so how clear data from row2 using current region without clear the headers in row 1?
thanks

 

[MARK858]

Try...

    With ws2.Cells(2, 5).CurrentRegion
        .Offset(1).Resize(.Rows.Count - 1).ClearContents
    End With

 

[abdo meghari]

excellent !
this is really helpful for me .
thank you so much .

 

[MARK858]

You're welcome