where to find all excel constants?
 

Hi Ryan,
If you have TLBInf32.dll:
Sub ExcelConstantsList()
Application.ScreenUpdating = False
Dim R, Member, i As Long, oPath As String
oPath = Application.Path & "\excel.exe"
With CreateObject("TLI.typelibinfo")
..ContainingFile = oPath
Workbooks.Add
For Each R In .Constants
i = i + 1
Cells(i, 1) = R.Name: Cells(i, 1).Font.Bold = True
For Each Member In R.Members
i = i + 1
Cells(i, 1) = Member.Name
Cells(i, 2) = Member.Value
Next Member
Next R
End With
Columns("A:B").Columns.AutoFit
End Sub

Or for one constant:
Sub xlConstantValue()
Application.Run "'iValue " & InputBox("Enter the constant name :" _
, "Excel constants", "xlBlanks") & "'"
End Sub

Sub iValue(I$)
MsgBox I, 64
End Sub

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