Thread: Move data to top of column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jasontferrell jasontferrell is offline
external usenet poster
  
Posts: 56
Default Move data to top of column
Use this:
Range("G:K").Sort Key1:=Range("G2"), Header:=xlYes
Reply With QuoteReply With Quote