If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Count the rows of Variable Tables Multiple times - Separated by a space

Thread starter jrake40
Start date Nov 30, 2016
Tags

count rows row count variable count variable data

jrake40

New Member

Nov 30, 2016

Hello,

I have a spreadsheet with multiple variable tables. I would like to get a count of rows for each table. The tables are separated by a blank row. Is there a way I can do this using VBA? The pattern could look something like this.

4 rows of data
blank row
3 rows of data
blank row
7 rows of data

Thanks,