Hi, Mukesh,

SpecialCells(xlCellTypeConstants) has 4 subtypes:
xlErrors      16  
xlLogical      4  
xlNumbers      1  
xlTextValues   2
If you add them up (which means allow any type of Constant values in the cells) you get the "mysterious" number of 23. As there must be Dates in the cells and these Dates are real dates, not mumeric text, i could have used 1 instead. But I wanted to include every possibilty so I choose the more comprehensive number of 23.


You need to spent reputation on somebody else before you are able to spend again on the same person. In ExcelForum it´s only 1 other person you need to "donate" to with this being laid down in the Admin Settings of vBulletin.

HTH,
Holger