1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| Sub MaFinLigne2(NumColonne as integer,MaFeuille as String) As Integer
' J.P Janvier 2015
dim oSheet as Object, oFinder As Object, oResult as Object, oCurrentController as Object
dim oColumn As Object, oCellRange As Object, oLastCell as Object
oSheet = ThisComponent.Sheets.getByName(MaFeuille)
'------- Recherche -------
oColumn = oSheet.Columns(NumColonne)
oFinder = oColumn.createSearchDescriptor
oFinder.searchRegularExpression = true
oFinder.SearchString = "."
oResult = oColumn.FindAll(oFinder)
'------- Le résultat contient les plages "non vide" -------
If Not IsNull(oResult) then
'on prend les index de la dernière cellule de la dernière plage
LastRangeNumber = ubound(oResult.RangeAddresses)
colNumber = oResult.RangeAddresses(LastRangeNumber).EndColumn
rowNumber = oResult.RangeAddresses(LastRangeNumber).EndRow
oLastCell = oSheet.GetCellByPosition(colNumber ,rowNumber)
oCurrentController = ThisComponent.getCurrentController()
oCurrentController.select(oLastCell)
End If
Mafinligne2 = rowNumber + 1 'pour avoir le même numéro que la dernière ligne d'affichage
End Sub
Sub Macro3
' 0 = colonne A - 1 = colonne B ,
Msgbox Mafinligne2(1,"csv70043")
end Sub |
Partager