Macro sorting data from another worksheet

S

slscanlon3

I have a file that sorts data from one worksheet onto another. It
refers to that worksheet by Activesheet.Next.Select and it worked fine.
If I try to hide that worksheet, it fails. How can I refer to a
hidden worksheet so this Macro will work as it does if it is not
hidden? The debugger always points to the worksheet identification as
the problem.
 
S

slscanlon3

That is what I was trying to do, but I must not be doing it
correctly...

If the sheet is named "data", how would I rewrite
Activesheet.Next.Select to refer to it.... I tried
Activesheet.data.select and it didn't work.
 
S

slscanlon3

I received a suggestion that I have to make the sheet visible to do the
sort and then make it invisible again.... is this the only way this can
be done?
 
Top