vba constants for excel

D

diver

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

Dave Peterson

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).
 
Top