最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

vba - LibreOffice Calc: return currentRegion for range - Stack Overflow

programmeradmin8浏览0评论

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 ?

发布评论

评论列表(0)

  1. 暂无评论