Biff
The problem is due to the wonderful line wrapping that happens with a post
myarray(Month(cell.Value)) = _
WorksheetFunction.Min(Day(cell.Value),
myarray(Month(cell.Value)))
is all one line of code.
The _ tells VBA to complie the next line as part of the current.
Try it as
myarray(Month(cell.Value)) = _
WorksheetFunction.Min(Day(cell.Value), _
myarray(Month(cell.Value)))
Hopefully the newsgroup engines will not introduce any unforeseen wraps
|