Coverting formulas to value but ignores formulas without value

[dache416]

Hello,

I have this workbook that have been working. One of the sheet name “Data II”, I want to convert the formulas to value from “Range A:G”, but only does formulas that has value. I have hidden formula propagates data from another sheet, it remains blank if the specific row has no value.

I found this macro online, it works fine, but it detect the hidden formula as having something in it. How can I make this macro ignores the hidden formula and only convert formulas that has value.

Please Login or Register  to view this content.

Thank you for your help.

Cheryl

[AlphaFrog]

What is a "hidden formula"? Do you mean that if the formula returns a blank, the cell that contains the formula is hidden?

[dache416]

Hi AlphaFrog,

Yes, and see attached workbook.

Thanks,
Cheryl

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[dache416]

Thank you very much AlphaFrog