Thread: sort table listobject without table name
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] oldyork90@yahoo.com is offline
external usenet poster
  
Posts: 59
Default sort table listobject without table name
I found it, it's listcolumns().range

http://www.msofficeforums.com/excel-...able-code.html

oLO_ma.Sort.SortFields.Add _
oLO_ma.ListColumns(IT_OWNER_COLUMN_NAME_BILLING).R ange, _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
Reply With QuoteReply With Quote