Copy and paste special disappear when I clear contents from cells

[ghrek]

Hi

I have a copy and paste special formula for some rows but when I clear contents on row im copying from the copy and paste special dissappears too.

Is there anyway to save it or have I got to reinput the formulas via macro every time I clear contents?

 

[Joe4]

I had set up a macro to clear the screens and then realised that I was clear screens too on the area where it was paste special to. DOH

Yeah, I thought maybe you had some other code interfering with it. That is often the cause.