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 ?