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 ?