vba code to clear data & formats from contigious and non contigious range to last data

[JEAN1972]

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

[TMS]

Why not try recording macros for each scenario while you complete the task manually? That will give you the basic code. It just need tweaking to cater for variable rows of data.