Thread: Max date
View Single Post
  #16   Report Post  
 
Posts: n/a
Default

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