Hi all

Must a ws be active to do a sort?

I have a button on sheet1 that, among other things, sorts data on sheet2,
before reactivating sheet1. Everything works fine, but I'd just as soon not
show the data on sheet 2 during the sort.

Any clues appreciated
anny

No it doesn't have to be active - it tends to be when the macro's been
recorded but you can jig the code so that the range being sorted is connected
directly to the sort method. You've just got to be careful you've specified
the correct sheet, not just as the range but as the key as well. Eg:

Worksheets("sheet1").Range("A1:A9").Sort
Key1:=Worksheets("sheet1").Range("A1"), Order1:=xlAscending

"anny" wrote:

Hi all

Must a ws be active to do a sort?

I have a button on sheet1 that, among other things, sorts data on sheet2,
before reactivating sheet1. Everything works fine, but I'd just as soon not
show the data on sheet 2 during the sort.

Any clues appreciated
anny

Why not just try it and see what happens?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anny" wrote in message
...
Hi all

Must a ws be active to do a sort?

I have a button on sheet1 that, among other things, sorts data on sheet2,
before reactivating sheet1. Everything works fine, but I'd just as soon
not
show the data on sheet 2 during the sort.

Any clues appreciated
anny

Well I did try it, to no avail. It turns out I hadn't specified the sheet
in the' key1:=', only the range, as Martin suggested above.

Thanks to both
anny

"Bob Phillips" wrote in message
...
Why not just try it and see what happens?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anny" wrote in message
...
Hi all

Must a ws be active to do a sort?

I have a button on sheet1 that, among other things, sorts data on
sheet2,
before reactivating sheet1. Everything works fine, but I'd just as soon
not
show the data on sheet 2 during the sort.

Any clues appreciated
anny