Question : vba count all row
Answered by : bhudis-wittayanusit
Sub CountRows1() Dim last_row As Long last_row = Cells(Rows.Count, 1).End(xlUp).Row MsgBox (last_row)
End Sub
Source : https://excel.officetuts.net/vba/count-rows-in-excel-vba/ | Last Update : Mon, 11 Oct 21
Question : vba number of rows
Answered by : m-duarte
Sub Count_Rows_Example1()
Dim No_Of_Rows As Integer
No_Of_Rows = Range("A1:A8")
End Sub
Source : https://www.wallstreetmojo.com/vba-row-count/ | Last Update : Thu, 26 May 22