Driving myself mad now.

After selecting a column I need to search for an exact number, eg 37. Not 6379 like its picking up at the moment. How can I make it select the cell with only the value I am looking for.
With the macro I'm using I'm unable to sort.

I know its a pants question but I'm going round in circles now.

 

Got it!

Selection.Find(What:="7", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate

The power of Scoobynet ....