View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Avery[_2_] Avery[_2_] is offline
external usenet poster
 
Posts: 1
Default Selection.Sort not working?

I'm trying to execute a simple sort on a selection in
Excel. The help file, as well as most of the online
guides I've read have suggested using:

Selection.Sort

However, even if I simplify my request to the following
lines, I still get the "application or user defined error"

Worksheets(1).Range("A27:H38").Select
Selection.sort


Anybody know what's going on here?

Thanks


Avery