{"id":3001,"date":"2018-09-05T11:25:29","date_gmt":"2018-09-05T11:25:29","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3001"},"modified":"2024-04-12T09:13:56","modified_gmt":"2024-04-12T09:13:56","slug":"count-rows-in-excel-vba","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/count-rows-in-excel-vba\/","title":{"rendered":"Count Rows in Excel VBA"},"content":{"rendered":"\n
There are a few methods to count rows and each of them uses VBA. In this example, I\u2019ll show two of them.<\/p>\n\n\n\n
This is the simplest way to count a number of rows on the worksheet, but at the same time, this method is not very universal. This method only works if there is a perfect table \u2013 you have the same amount of data in each column.<\/p>\n\n\n\n