E
Excel Monkey
Can someone tell what the .Type Property means for a Reference object in a VB
Project? See example below. I get a Type of 0 for all my references.
Sub VBERefList()
Dim chkRef As Reference
Dim vbProj As VBProject
Set vbProj = ThisWorkbook.VBProject
For Each chkRef In vbProj.References
Debug.Print chkRef.Type
Next
End Sub
Thanks
EM
Project? See example below. I get a Type of 0 for all my references.
Sub VBERefList()
Dim chkRef As Reference
Dim vbProj As VBProject
Set vbProj = ThisWorkbook.VBProject
For Each chkRef In vbProj.References
Debug.Print chkRef.Type
Next
End Sub
Thanks
EM