Clear Values Containing no formulas

[howard]

I have a spreadsheet containing text, Values as well as values with Formulas.

I need to write VBA code to clear the values where there are no formulas. The Text must be left intact, only the values containing no formulas must be cleared.

Your assistance will be most appreciated.


Howard

 

[Richard Schollar]

Hi Howard

You can probably use the SpecialCells method:

Range("A1:H100").SpecialCells(xlCellTypeConstants,xlNumbers).ClearContents

Best regards

Richard

 

[howard]

Hi Richard

Thanks for the help

Regards

Howard