Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return the Object that belongs to a CodePage

Thread starter BruceMutton
Start date Mar 23, 2002

Status: Not open for further replies.

Mar 23, 2002

BruceMutton

Geotechnical

The opposite of this is easy to do, using
[tt]Object.CodePage[/tt]
however [tt]CodePage.Parent[/tt] only steps up the VBA object hierachy towards the VBE.

The only way I can think of is by brute force...
[tt]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 <> [/tt]

Any better ideas?