View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mark Bigelow Mark Bigelow is offline
external usenet poster
 
Posts: 55
Default Macro is giving me problems with sorting

Make sure you have the following Header part in your sort code:

Range("A:A").Sort Key1:=Range("A1"), Header:=xlNo

This tells Excel that the first line is not a header and to go ahead and
sort it.

Let me know if that doesn't work.

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!