Hello,
Tom Ogilvy recently posted some instructions on how to sort
information in a spreadsheet with VBA. Since then I’ve done some
research and I have a few questions. VBA Help gives the following
example:

This example sorts the region that contains cell A1 (the active region)
on Sheet1, sorting by the data in the first column and automatically
using a header row if one exists. The Sort method determines the active
region automatically.
Worksheets("Sheet1").Range("A1").Sort _
Key1:=Worksheets("Sheet1").Columns("A"), _
Header:=xlGuess

My questions a
1) How does the sort method determine the active region automatically?
Are there any circumstances under which it is not reliable?
2) What criteria does it use in determining whether or not there is a
header? Is that reliable?
3) What other options are there besides xlGuess, which makes me
uneasy?

Thanks in advance for all your help. - Pikus


---
Message posted from http://www.ExcelForum.com/