Counted used rows in a range

[J047]

Hello everyone,

I'm brand new at vba and trying to sort out

I have a number of table (up to 35) in a spreadsheet - one below the other and I need to convert them into chart. My problem is that they don't have the same number of used rows - It varies from 6 to 23.

Could someone help my find a way to count the used row in a specific range?
I need to store that number as a variable and insert it in my loop.
So far all I've been able to do is count the number of used rows in a spreadsheet...

Thanks a lot,

J

[Bob Phillips]

There are many ways, and the 'correct' way will depened upon exactly wht you want and hoe the dat is organised.

Here is one such way

Activecell.CurrentRegion.Rows.Count