You can use the immediate window to test the value of any variable
(after it is assigned) or constant like this:

INSIDE the Immediate window (View MENU or Ctrl+G):

? xlDescending ' You type  this
2 ' VBA responds

OR
print xlDescending
2

Also, if you leave this "print" line in the Immediate window, you can
go back any time, click *anywhere* in the line and hit ENTER to get the
current value.

There's also an F-Key (Don't have my cheat-sheet here) that will
display the value when you click (Or is it hover over) a variable.
ALSO, if the error enters the BREAK mode (Line of code highlighted in
yellow) hovering over variables/objects in that SUB will show the value.