offset and clear
 

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

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
--
Don Guillett
SalesAid Software

"Kevin" wrote in message
om...
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