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

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

--
Regards,
Tom Ogilvy

"mike allen" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>