I got it finally -
Set hashrange = .Cells.Find(What:="##", After:=.Cells(.Cells.Count), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False)
If Not hashrange Is Nothing Then
hashrange.Columns.AutoFit
End If
This not a duplicate post as suggested, the solution I was after was the fastest method of finding overflowed cells without iterating rows or columns in vba - which is too slow (for me) in large sheets.
Hope someone finds this useful - using this in my app now Excel Database Tasks
Thank you very much for all responses.