xlBlanks is a constant for pivot tables according to the object browser.
The constant you are actually using is xlCellTypeBlanks as an argument to
specialcells. xlBlanks is actually the pre-excel 97 constant used with
specialcells, so MS has preserved the value so they both evaluate to 4.

So you see documentation might not be a definitive as you would expect.

In later versions of excel I believe there is a list of constants in the
Excel VBA help file.

--
Regards,
Tom Ogilvy



"Ryan H." wrote in message
le.rogers.com...
Hi,

I'm wondering where I can find all the excel contants listed and their
explanation? For example, I learned a couple of days ago og the xlBlanks
constant, and how to use it to find blank cells. What if I want to find
out
if there is such a constant for finding filled up cells. Is there a
webpage
out there or a resource I can look up to find these constants?

Thanks