[RESOLVED] Formula in Excel

[jivangoyal]

I need to Search all the excel sheets that contains some kind of formula. Is there any method that can give this information.

[Siddharth Rout]

To get the cell that contains formula, you can use the following two properties in Excel VBA

1. .HasFormula
2. .SpecialCells(xlCellTypeFormulas)

.HasFormula will give True or False depending on the availability of formulas whereas .SpecialCells(xlCellTypeFormulas) can be used to select all the cells that contain formula

cells.SpecialCells(xlCellTypeFormulas).Select

or

Set rng = cells.SpecialCells(xlCellTypeFormulas)

For each Cll in Rng

'~~> Your code for each cell containing formula

Next

Hope this helps...

[jivangoyal]

Thanks a lot for quick solution.