How do I clear contents from a range excluding formulas and text?

**Normezo** · 07-23-2012, 06:19 AM

Hi!
I have a range where some cells contain formulas, i want the cells with constants cleared and leave the formulas.
I thought i coul use SpecialCells, but there may be empty cells in my range, so i get error code 1004 cells not found.
Any idea how i can solve this?
Thanks

Example range:

January
Formula
Formula
100%
70%
80%
Empty cell
Empty cell
100%
80%
Formula
90%
100%
80%
EmptyCell

**Andy Pope** · 07-23-2012, 06:56 AM

I used the following without error.

Please Login or Register  to view this content.

Maybe you can post an example workbook and the code you are using.

**Normezo** · 07-23-2012, 07:22 AM

Hi!
Thanks for quick response!
I get the runtime error using this when one of my ranges contains all blanks, use "On error resume next", and it worked, even though i dont like using On Error.

Some of the cells I want cleared contains equal sign f.ex: =0,1
How do I clear these as well?
code i'm using:

Please Login or Register  to view this content.

**Andy Pope** · 07-23-2012, 07:26 AM

If ALL the cells are blank then yes you would get that error.

Nothing wrong with using the error trapping like that.

unless the cell is formatted a Text then =1,0 is a formula.

**Normezo** · 07-23-2012, 07:30 AM

Thank you again for the help! I'll adapt my workbook then and a strict note in the "How to" userguide that those cells should only contain constants!
Thanks again!

**Cutter** · 07-23-2012, 10:36 AM

@ Normezo

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.