[Solved] How do I get the sheet index?

antrrax · Post by **antrrax** » Tue Mar 05, 2019 4:12 pm

I have an object with my sheet, which was created from the sheet name.

Dim oDoc, oMySheet As Object

oDoc = ThisComponent
oMySheet = oDoc.Sheets.getByName("Base")

How do I get the index this sheet: 'oMySheet' ?

Thanks!

Post by **Zizi64** » Tue Mar 05, 2019 4:37 pm

iSheetNr = oMySheet.RangeAddress.Sheet

Ibstall and use one of the excellent object inspection tools, like the XrayTool and MRI.

antrrax · Post by **antrrax** » Tue Mar 05, 2019 5:04 pm

Thank you, that's what I needed.

I'll start using XrayTool