using dcount on a variable data range

[JohnJC]

I want to use dcount on a data range, but the number of rows of data will
vary depending on a calculated value elsewhere in the S/S. Is there any way
of dealing with this without going into VB programming?

I can record a macro but cannot write them from scratch

[Miguel Zapico]

You may use dynamic named ranges. There are some examples at:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Hope this helps,
Miguel.

"JohnJC" wrote:

> I want to use dcount on a data range, but the number of rows of data will
> vary depending on a calculated value elsewhere in the S/S. Is there any way
> of dealing with this without going into VB programming?
>
> I can record a macro but cannot write them from scratch
>
>