Macro for changing number of rows

Hello -

So I'm a little less experienced than I thought.

Below is my table.

Please Login or Register  to view this content.

My little macro orders the rows in descending order by column C, then orders the rows in descending order by Column B. But it's hard coded to 6 rows. I don't know how to make it apply to whether I have 30 records or 3,000 records. FYI, the number of columns will be fixed at 3 columns no matter how many records I have.

Please Login or Register  to view this content.

Any help would greatly be appreciated.

Thanks for your help in advance.

- DyingIsis

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

EDIT: Also, please explain what you're trying to do.

Try this:

Please Login or Register  to view this content.

shg, thank you thank you thank you!!!

I'm trying to learn how to do this kind of thing on my own, but I'm obviously way inexperienced.

Do you have any tips on reading materials or courses for someone who is trying to learn how to manipulate Macros via VBA?

try recording a macro it will give you some ideas.
the one above by shg looks like this when recorded

Please Login or Register  to view this content.

you can then change the selection bit

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

i also learn from here...thanks!