Sometimes, if you just change the format of that header row (Bold or italics or
underlined), then excel will see it as different and guess that it's a header
row.

(I don't know why it forgets--but I always select my range to sort anyway.)

Frostfire wrote:

Suddenly, when I choose sort, it tries to use the column letters, rather than
my header row. I have to highlight the entire document, set this as the
'Print_Area', and then the sort will recognize my header row. It was working
just fine, until recently, and I can't figure out what's changed.

--

Dave Peterson