Contar Numero De Filas En Excel Vba [UPDATED]

Sub CountRowsSpecificSheet() Dim rowCount As Long ' Count rows in column A of "Sheet1" rowCount = Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row

' Find last row with data in column A On Error Resume Next lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row On Error GoTo 0 contar numero de filas en excel vba

Existen varias formas de contar el número de filas en Excel VBA. A continuación, te presento algunas de las formas más comunes: Sub CountRowsSpecificSheet() Dim rowCount As Long ' Count

Dim ultimaFila As Long ultimaFila = Cells(Rows.Count, 1).End(xlUp).Row Use code with caution. Copied to clipboard contar numero de filas en excel vba