Code to clear contents

D

Dave Peterson

Rows are numbered. Columns are lettered (or numbered??).

with activesheet
'clear all the contents of rows 2:65536
.range("2:" & .rows.count).clearcontents
'clear all the contents of columns B:IV
.range(.columns(2), .columns(.columns.count)).clearcontents
end with
 
J

jk

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.
 
Top