My mistake , it is row 1, columns A through K. I need it to be automated
instead of constantly highlighting all rows/columns then hitting delete. I am
new to coding so i need to clear all contents except for criteria row1,col A
through K.

" wrote:

Do you mean column "A"?
jk wrote:
Is there a code to clear all contents of a sheet with the exception of row
"A" .