Special Cells method
In Excel API, I can't choose cells based if they have formulas or values.
In VBA, I can do that by using Range.SpecialCells method. Also, I can specify if I want to get only text values, numbers, errors and/or booleans.
Felipe Gualberto commented
Nice, thanks! It would be great to have a documentation listing the possible values of enumerations SpecialCellType and SpecialCellValueType.