Karen,

Those are the values of the different Calculation modes.

In the VBE, hit [F2], enter "xlCalculation" in the search box. In the Search
Results box, select any of the items that have "XlCalculation" in the Class
column. Then in the "Members of 'XlCalculation'" pane below, select each
constant of the XlCalculation class, then look in the gray/tan box at the
bottom to see the values for each constant.

As far as returning the names......sorry, can't help you there.

HTH,

Conan




"Karen53" wrote in message
...
Hi,

How do I check the status of xlCalculation (Manual or Automatic) in a
debug
statement?

I tried

Debug.Print "Starting NuTenant " & Application.Calculation

I'm getting results like -4105 and -4135
--
Thanks for your help.
Karen53