vba constants for excel
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 |
All times are GMT +1. The time now is 05:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com