offset and clear

K

Kevin

Hi
I have a worksheet that contains daily data
i fill column A with a formula which is the index for the data.
what i want to do is check column B for <>"" (this means an index
number assigned) i then want to clear the contents of column A below
the last record
in column B

thanks

kevin
 
D

Don Guillett

this ??
cblr=cells(rows.count,"B").end(xlup).row
calr=cells(rows.count,"a").end(xlup).row
range(cells(cblr+1,"a"),cells(calr,"a").clear
 
Top