View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Rewriting equation for VB

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