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