View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dolivastro@gmail.com is offline
external usenet poster
 
Posts: 46
Default Do Until syntax problem

The second form is wrong. The first form can be made clearer if you
include parentheses:
Do Until (Range("Current_Date").Value - ActiveCell.Value) < 361

But in either case it should not error out. Are you sure the range
"Current_Date" is correct? If not the error should be on the Range
Method, not the "Do" or "Until" statements.

Hope this gets you started,
Dom



excelnut1954 wrote:
Can someone please tell me what is wrong with this command?

Do Until Range("Current_Date").Value - ActiveCell.Value < 361

I tried to add at the end,

Do Until Range("Current_Date").Value - ActiveCell.Value < 361 = True

but it still errors out.

Any suggestions? I've browsed examples here, and couldn't find anything
similar to what I'm doing.
Thanks,
J.O.