abdo meghari
Active Member
- Joined
- Aug 3, 2021
- Messages
- 469
- Office Version
- 2019
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 will be sheet reference is sheet1
so how clear data from row2 using current region without clear the headers in row 1?
thanks
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
VBA Code:
ws2.Cells(2, 5).CurrentRegion.ClearContents
so how clear data from row2 using current region without clear the headers in row 1?
thanks