Active Workbook issue

[annek]

I am very new to writing/recording macros. I have code that works for sorting data in a worksheet. I recorded a macro, and then copied the code into my other macro in VBA. However, I want to be able to run the macro on any worksheet. When I recorded the macro, it identifies the specific active worksheet I was working in.

How do I change the following code so that I can use this macro on any worksheet that I open?

Please Login or Register  to view this content.

I also want to change the range I sort to capture however many lines of data the new worksheet may have. It may have 4000 rows, it may have 6000 rows. How do I change that?

Thank you!

[shg]

Do you want to sort the entire used area of the worksheet?

[annek]

No. I want to sort the entire workbook by column J (starting at row2), and then where there are no values in column J, I want to sort by column H. I'm attaching a sample of my data--maybe that will help show what I need.

[annek]

Sorry--I said workbook, but I mean worksheet.

[shg]

This sorts the active worksheet:

Please Login or Register  to view this content.

[annek]

That worked for sorting by column J. Thanks!

Now, how do I sort all the data at the bottom of the worksheet (where there aren't values for J) by column H? At this point, I don't want to sort the entire worksheet. Just what doesn't have values for J.

[annek]

I just looked at my data, and the code above sorts my column headings with the data, which I don't want. My column headings are on Row 3, so I changed "J2" to J3", but that didn't work. What can I do to fix this.

Thanks for bearing with my VBA ignorance.

[shg]

In your example, the header was in row 2; not so?

[annek]

Correct, row 2 is my header. Your code works just like I want on my test file, however, when I run it on my larger worksheet (over 4700 lines), the header is sorted into my data, and the sort on column H doesn't appear to work.

[annek]

This is a more accurate example of what I'm working with, but on a much larger scale. When I run your macro on this, the header gets sorted along with the data.

[shg]

Please Login or Register  to view this content.