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.
|