View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TonyD TonyD is offline
external usenet poster
 
Posts: 29
Default Open Worksheet Sort Data

When I open a worksheet (Refer To CT), I want to automatically sort a named
range by column A in descending order so that blank row are at the bottom.
The named range is "CTReferRecords". Can anyone help me with the code?