I can't find my error. I've tried Adding "Set" in front of "colcnt = rng.Columns.Count", where the error is highlighted. I tried several other changes, but no luck. I'm using Excel 2011 on a Mac.
Please help!
Sub FindSales()
Dim rng As Range
Dim colcnt As Long
Dim sortv As String...