Clearing Contents in a range of cells but keeping formulas.

Hi Again,

I have received excellent help on a spreadsheet so far, so much show that I showed one of my colleagues who was very impressed and said he would like to use it too, but when the contents of a cell are cleared, is it possible to leave formulas in there? i have tried adding "ButFormulas" on to the end of .ClearContents but that didn't seem to work.

Here is a link to my original thread.

This is the code I am currently using thanks to the help received in here earlier.

Please Login or Register  to view this content.

Thanks in advance

Thanks! That works. Some lines (depending on the type of case) I get an error message saying

" Run-time error '10040: No cells were found"

It actually does exactly what I want though. Is there anyway to stop that error popping up?

Have I taken you too literally?

Please Login or Register  to view this content.

doesn't seem to work in this context

Please Login or Register  to view this content.

You are my offices hero by proxy! Thank you