Rewriting equation for VB
This? Or have I missed something?
MaximumScale = 5 * Application.RoundUp((Max / 5) / (10 ^ (Len((Max / 5)) -
1)), 0) * (10 ^ (Len((Max / 5)) - 1))
"Barb Reinhardt" wrote:
I have the following equation
.MaximumScale = 5 * RoundUp((Max / 5) / (10 ^ (Len((Max / 5)) -
1)), 0) * (10 ^ (Len((Max / 5)) - 1))
Max is a value that's previously been determined and the formula are the
Excel equivalents. How do I rewrite this so that it's evaluated
programmatically?
Thanks in advance,
Barb Reinhardt
|