Hi All

looking for a code as follows to last data row

Sheet Data

Row 1 has headers from column A to Column Z


1)Code to clear data only not formats from row A2 to row Z2 to last row of data contigious range

2)Code to clear data and formats from row A2 to row Z2 to last row of data contigious range

3) Code to clear data at specific columns non contigious range
e.g column B ,F,G,M,N,P ,R, T

3b)Code to clear data and formats at specific columns non contigious range .
e.g column B ,F,G,M,N,P ,R, T

NOTE headers at row 1 shoud not be clear

Thanks if anyone can assist