If anyone interested I've found a solution.

use Range.Dependents - gives you all the cells that are formulas and the
formulas "contains" the Range
or
Range.SpecialCells(xlCellFormulas) - gives you all the cells in the Range
that are formulas

"Peter T" wrote:

In theory maybe yes but difficult to comment without any details as to what
you have and what you want. At the very least it would need to be tailored
to your set-up and requirements.

Regards,
Peter T

"ARHangel" wrote in message
...
Is there a way without knowing the cells with formulas?