Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|