where to find all excel constants?
Ryan, the constants are indexed in the .olb files to the version xl2000.
Using TLBInf32.dll and according to the version of Excel:
Sub ExcelConstantsList()
Dim Version As String
Select Case Val(Application.Version)
Case Is = 10: Version = "excel.exe"
Case Else: Version = "excel" & Val(Application.Version) & ".olb"
End Select
Application.ScreenUpdating = False
Dim R, Member, i As Long
With CreateObject("TLI.typelibinfo")
..ContainingFile = Application.Path & "\" & Version
'...
Regards,
MP
"Ryan H." a écrit dans le message de
le.rogers.com...
Hi,
I'm wondering where I can find all the excel contants listed and their
explanation? For example, I learned a couple of days ago og the xlBlanks
constant, and how to use it to find blank cells. What if I want to find out
if there is such a constant for finding filled up cells. Is there a webpage
out there or a resource I can look up to find these constants?
Thanks
|