seldom
range("a1:x12").select
selection.sort
can be
range("a1:x12").sort

pastevalues can be
range("a1:x12").value = range("b1:y12").value
range(destingationrange).value = range(sourcerange).value

--
Don Guillett
SalesAid Software

"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