What is it you are trying to do??????? that workbook does NOT contain any code. Adding my code to it and running it produced no errors!
Simon
as i stated in m ylast post i am jez trying to clear the data , but not the formula using the macro assigned to the button thats all
i dont know why it gives me error withte same code what u have sent me , if i am trying to change the range say l46 :m56 instead of h22:r33
oK LET ME TELL U WHAT IS HAPPEING
the macro what u sent erase the cells from h22:r33
but when i try to change the range from l46:m56
it says cells not found
and going to the debug mode
1.is this true once the cell data is cleared , the formula retained, the cells filled again , still the macro code recognizes it to be cleared cells?
that is all i know about what is happening
2. Also there is another situation here
as u c inthe excel i sent h28 is used in L46 as a formula for example
when i use the macro to clear the data in l46 to m56
then comes the error cell not found though there is data in there bu the good thing is the formulas are not erased
and goes into the debug mode
please advice me