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


jk wrote:

Is there a code to clear all contents of a sheet with the exception of row
"A" .

--

Dave Peterson