admin管理员组

文章数量:1321242

I would like to apply a filter to a region through a VBA macro and I don't want to hardcode the region.

In Excel VBA, I can use the myrange.currentRegion method that returns the region to which belongs the range object.

I'm looking for an alternative in LibreOffice VBA

dim shtData as object
shtData= thisComponent.Sheets.getByName("MASTER INDEX")
'rgeData=shtData.getCellRangeByName("A1:F32") ' hardcoded region
rgeData =  shtData.getCellRangeByName("A4").CurrentRegion ' "CurrentRegion" is not known in LibreOffice VBA

Any suggestion ?

本文标签： vbaLibreOffice Calc return currentRegion for rangeStack Overflow

版权声明：本文标题：vba - LibreOffice Calc: return currentRegion for range - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742097857a2420660.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。