I'd like to find out how many rows there are in a particular column of a named range. For example I have this range named Rreferences
2 2 2
4 6 3
5 7
8
So it's a 3x4 size range. I would like to be able to count the rows for each individual column. I've tried things like
k= Rreferences.Columns(2).Rows.count
k=Rreferences.Columns(2).UsedRange.Rows.Count
but nothing seems to work. Any ideas?!?
Bookmarks