Hey All;

How can I convert this formula to VBA?

=MROUND((COUNT($B$1:$B413)/COUNT($B:$B)*100),5)
using the result of VBA's Find function as the changeable row number.

win98 excel2002

Thanks, Jay