Do Until problem

[David Goodall]

Morning
I've set up a do until loop but it doesn't stop when the two conditions
appear to be the same.

The two variable I'm comparing are declared as Double and I think that's
where the problem lies. When I debug the watches are as follows:-

Variable1 = 39779.4028
Variable2 = 39779.4028

They appear to be the same but I'm thinking that not all the decimals are
being shown. I only need the answers to 2 decimal points ie 39779.40 so
would you suggest casting the double to another variable type.

Hope this makes sense.
Thanks
David

[Bob Phillips]

David,

How about

Do
...
Loop Until Round(var1,2) = Round(var2,2)


--
HTH

Bob Phillips

"David Goodall" <[email protected]> wrote in message
news:[email protected]...
> Morning
> I've set up a do until loop but it doesn't stop when the two conditions
> appear to be the same.
>
> The two variable I'm comparing are declared as Double and I think that's
> where the problem lies. When I debug the watches are as follows:-
>
> Variable1 = 39779.4028
> Variable2 = 39779.4028
>
> They appear to be the same but I'm thinking that not all the decimals are
> being shown. I only need the answers to 2 decimal points ie 39779.40 so
> would you suggest casting the double to another variable type.
>
> Hope this makes sense.
> Thanks
> David
>
>
>