Ok thanks, If I loop thru the collection how can I get the max?

On Nov 7, 5:02 pm, "Norman Jones"
wrote:
Hi Don,

What relationship has Columns("d") with the OP's collection?

---
Regards,
Norman

"Don Guillett" wrote in l...



Sub getmax()
MsgBox Application.Max(Columns("d"))
End Sub
--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hi Fellows

How can I get the Max number from a collection thata has only numbers

Thanks
GC- Hide quoted text -- Show quoted text -