I see some people use “SpecialCells(2)” in their code. Although I do not know what it means, I can guess it may be another way of referring to the type special you find in CTRL plus G in excel. The number may refer to either of these. XlFormula, Xlnumber, Xlconstants and etc.

If my guess is correct, how do I know what the numbers in bracket (1), (2) refer to. For e.g. what is SpecialCells(1)mean? I am unable to find these in excel helpline. Please help!