That should be XLConst, not XLList.

BTW, colors don't have an Excel constant value, automatic and none apart,
you just have to know their colorindex, that is the index within the colour
palette.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
Chip Pearson has a workbook with the values at
http://www.cpearson.com/excel/download.htm. Look for XLLIst at the bottom
of
the page.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mo" wrote in message
...
I'm working on an Access application that I must use late binding vs
early
binding for. Unfortunately this means that I cannot use xlcentered,
etc.
I
must know the numerical values. For example for the horizontalalignment
I'm
using 7 for centered. I want to center my verticalalignment as well.
I've
tried 7 assuming it might be the same as for horizontal but it didn't
work.
I have the same problem for changing the colour of the cells. I'd
really
appreciate any help someone can give me with this. Any suggestions,
books
etc. that spell out these values would also be a welcome bit of insight.
Thanks and have a great weekend!