View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon[_21_] Jon[_21_] is offline
external usenet poster
 
Posts: 37
Default Using FoundFiles to list by path and filename

figured it out, i just did a sort ascending command. works like a
champ.

range("B9:F" & count + 9).Select
Selection.Sort Key1:=range("B9"),
Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal