Return the Object that belongs to a CodePage
Return the Object that belongs to a CodePage
(OP)
The opposite of this is easy to do, using
Object.CodePage
however CodePage.Parent only steps up the VBA object hierachy towards the VBE.
The only way I can think of is by brute force...
For Each <worksheet & object> In ThisWorkbook
If <worksheet & object>.CodePage Is <codepage I'm looking for> Then
Msgbox "This is the Object that belongs to the CodePage!"
End If
Next <>
Any better ideas?
Object.CodePage
however CodePage.Parent only steps up the VBA object hierachy towards the VBE.
The only way I can think of is by brute force...
For Each <worksheet & object> In ThisWorkbook
If <worksheet & object>.CodePage Is <codepage I'm looking for> Then
Msgbox "This is the Object that belongs to the CodePage!"
End If
Next <>
Any better ideas?




