On Sun, 7 Sep 2008, in microsoft.public.excel.programming,
Del Cotter said:
Dave Peterson said:
How do I sort using the first *three* columns as primary,
secondary and tertiary keys?

With worksheets("someworksheetnamehere").range("Sort_Ro ws")

I eliminated the "worksheets" part of the range reference, which I
assume makes the macro work on whatever worksheet is in focus at the
time?

After some reading, I guess it would be better practice to write

With ActiveSheet.Range("SORT_ROWS")

rather than

With .Range("SORT_ROWS")

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.