What does SpecialCells(2) mean?

**AB33** · 10-01-2012, 08:59 AM

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!

**buran** · 10-01-2012, 09:12 AM

Your guess is correct. The answer to your question - look in the Help.
Here it is:

Excel Developer Reference
XlCellType Enumeration
Specifies the type of cells.
Name Value Description
xlCellTypeAllFormatConditions -4172 Cells of any format.
xlCellTypeAllValidation -4174 Cells having validation criteria.
xlCellTypeBlanks 4 Empty cells.
xlCellTypeComments -4144 Cells containing notes.
xlCellTypeConstants 2 Cells containing constants.
xlCellTypeFormulas -4123 Cells containing formulas.
xlCellTypeLastCell 11 The last cell in the used range.
xlCellTypeSameFormatConditions -4173 Cells having the same format.
xlCellTypeSameValidation -4175 Cells having the same validation criteria.
xlCellTypeVisible 12 All visible cells.

**AB33** · 10-01-2012, 09:49 AM

Buran, You are the rising star of this forum and will give you the top star.

For some unknow reason, I am unable to find the help function in 2010. In excel 2007, whilst I am in VB page, I can press the F1 and go to the developer page, but if I do the same in excel 2010, I get a different page. I am sure, I am missing something. In excel 2007, I also used to highlight any varaible and hit the F1 button, so I do not know and where to find the helpline in excel 2010.

**buran** · 10-01-2012, 09:57 AM

Thanks for the kind words :-).
I don't know why you get different help page. I just tried on Excel 2010 and I get the same page. I put the cursor on SpecialCells and hit F1. Maybe you should use F2 and browse to find the Range.SpceialCells property.

Buran

**AB33** · 10-01-2012, 10:23 AM

Yes, the F2 works. Where are the star icons?

**buran** · 10-01-2012, 10:25 AM

Down left corner of every user's post, star and triangle. thanks :-)
F1 should work also if you put the cursor in the code...

**AB33** · 10-01-2012, 10:43 AM

I am sure I am missing something. While I am at VBA page, highlighted the word SpecialCells and hit the F1 key, now all I can see is excel help and Categories. Even if I type the word SpecialCells on the excel help page, I get three serach topics on SpecialCells. In excel 2007, If type the same word, I get many pages on the same topic.