Macro sorting data from another worksheet

  • Thread starter Thread starter slscanlon3
  • Start date Start date
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.
 
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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Macro won't run correctly when a worksheet is hidden 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Rename worksheets macro 2
Email Worksheet Question 3
Rename worksheets macro needed 3

Back
Top