count within a range
 

I think this is simple, but I am stuck. I have a named range with 6 rows
and 4 columns. Not all cells in this range are occupied. I want to count
the number of entries on the 5th row of this range, for instance. There are
many named ranges I want to use the same code on, so I do not want to just
hard reference that section of that range. I am wanting to use the
'application.counta' function vs. a loop. Thanks, Mike Allen

count within a range
 

application.CountA(Range("MyRange").Rows(5))

--
Regards,
Tom Ogilvy

"mike allen" wrote in message
...
I think this is simple, but I am stuck. I have a named range with 6 rows
and 4 columns. Not all cells in this range are occupied. I want to count
the number of entries on the 5th row of this range, for instance. There
are
many named ranges I want to use the same code on, so I do not want to just
hard reference that section of that range. I am wanting to use the
'application.counta' function vs. a loop. Thanks, Mike Allen