Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Constants in Excel | Excel Discussion (Misc queries) | |||
vba constants for excel | Excel Discussion (Misc queries) | |||
where to find all excel constants? | Excel Programming | |||
where to find all excel constants? | Excel Programming | |||
changing the constants in the find function | Excel Programming |