Is there a book or online reference that contains a list of the values of
predefined VBA constants for Excel (e.g. xlDown, xlPasteValues)?

In Microsoft Visual Basic HelpMicrosoft Excel Constants


"diver" wrote:

Is there a book or online reference that contains a list of the values of
predefined VBA constants for Excel (e.g. xlDown, xlPasteValues)?

If you're only looking for one or two of these, you can open the VBE, hit alt-g
(to get to the immediate window) and type:

?xldown
you'll see
-4121

Another way is to just search for xldown in the object browser (F2 while in the
VBE).

diver wrote:

Is there a book or online reference that contains a list of the values of
predefined VBA constants for Excel (e.g. xlDown, xlPasteValues)?

--

Dave Peterson