Special Cells Numbers

[Sahil123]

Hi All,

I have tried recording a macro to give me formulas within a range with numbers and text etc and have tried several different combinations to see what the code is like but i get numbers.

Is there a list to show me what numbers are what and with a combination of text and numbers etc gives different number

i.e i got this

Sheets("Sheet1).Range("B1:B20").SpecialCells(xlCellTypeFormulas, 3).Select

 

[mikerickson]

If you look at the Object Browser in the VBEditor and use the search term "specialcells", one of the options will be the Enumerated class xlSpecialCellsValue which will list the constants xlErrors, xlNumbers, xlLogiclal and xlTextValues.
I find it easier to use named (descriptive) contestants than there value in coding

Sheets("Sheet1).Range("B1:B20").SpecialCells(xlCellTypeFormulas, xlNumbers).Select

 

[Sahil123]

what about multiple selections like formulas with numbers and text etc

 

[mikerickson]

For numbers and textvalues,

Sheets("Sheet1).Range("B1:B20").SpecialCells(xlCellTypeFormulas, xlNumbers + xlTextValues).Select

Unfortunatly, one can't use this approach for Formulas and Constants, Union has to be used to combine cell types.