Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 01/31/2022 in all areas

  1. Latest update just released. See below for change log.
    4 points
  2. As the WebDriver UDF - Help & Support thread has grown too big, I started a new one. The prior thread can be found here.
    1 point
  3. Maybe something like this? #include <Excel.au3> ; Pass the following parameters: ; * Object of the Workbook ; * Number or Name of the Worksheet ; * Name or Index number of the table ; * Name or Index number of the Column Func FindLastRowInExcelTable($oWorkbook, $vWorksheet, $sTable, $iColumn) Local $xlByRows = 1 ; Searches across a row, then moves to the next row. Local $xlPrevious = 2 ; Search for previous matching value in range. Local $iLastRow, $oWorksheet, $oTable $oWorksheet = $oWorkbook.Sheets($vWorksheet) $oTable = $oWorksheet.ListObjects($sTable) With $oTable.ListColumns($iColumn).Range $iLastRow = .Find("*", .Cells(1), $xlFormulas, $xlPart, $xlByRows, $xlPrevious, False).Row EndWith EndFunc ;==>FindLastRowInExcelTable
    1 point
  4. For $n = 1 To $CmdLine[0] ; UBound($CmdLine) -1 ConsoleWrite($n & @TAB & $CmdLine[$n] & @CRLF) Next
    0 points
×
×
  • Create New...