You need to Select the appropriate cell when calling FreezePanes.
Off the top of my head, that's the only time you need to use
Select.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"John Coleman" wrote in message
oups.com...
Greetings,
I tend to regard .Select as the goto of Excel VBA: it is
seldom
necessary and makes code harder to read, not to mention slower.
Nevertheless, I do sometimes use it - but (if I am honest) only
in
cases where I do not really understand the object model (which
in my
case includes things like PasteSpecial and Sort) and thus rely
on
editing code from the macro recorder. Is it *ever* necessary to
select
a range before performing some operation involving it? Just
curious.

Have a good day

-John Coleman