Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I want to clear contents of column A, B and C but keep Headers (Cells A1, B1 and C1) data is not fixed for certain row I want to clear till the last cell with data
CONCATENATE Macro.xlsx.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Description | Amount | ||
2 | 1 | A B C D E F G H I J | 1 | ||
3 | 2 | A B C D E F G H I | 2 | ||
4 | 3 | A B C D E F G H | 3 | ||
5 | 4 | A B C D E F | 4 | ||
6 | 5 | A B C D E F | 5 | ||
7 | 6 | A B C D E | 6 | ||
8 | 7 | A B C D | 7 | ||
9 | 8 | A B C | 8 | ||
10 | 9 | A B | 9 | ||
11 | 10 | A | 10 | ||
Sheet1 |