what is the corresponding value of xlCenter and xlBottom

Here's an easy way to get the value of Named Constants. In the Immediate Window of the VBE
....Type: question mark..a space...the constant to evaluate...Press Enter.
....The value will be returned.

Example:

? xlCenter
-4108
? xlBottom
-4107