Thread: WEND in VBA
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default WEND in VBA

"Dana DeLouis" wrote in message
...
While Abs(kw - Price) 0.00005


It appears to me that kw could be a typo.
Looking at the code, my guess is that it should be

While Abs(k2 - Price) 0.00005

It appears to loop until k2 (Pv) calculation is reduced to a value close
to Price.

Since "2" is next to "w" on the keyboard, my guess is that it should be
k2, and not kw.



I seems that when Gord Dibben said to me that other day:

That's why there is a great herd of us monitoring these groups.


he wasn't kidding!

These NG's never cease to amaze me!

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk