Creating a custom sorting

Hello everyone,

I am trying to create a custom sorting in VB. My sorting needs to be first on column B, then C and last on G. My data does not have headers.
How do I create such a custom sorting?

Thanks in advance?

Record a macro going through each of the subsequent sorting steps. Post the code and workbook for help on cleaning up the code.

Maybe like this:

Please Login or Register  to view this content.

If you create a dynamic named range for your data, you could avoid the hard-coded references:

Please Login or Register  to view this content.

In conjunction with shg's suggestion to use a dynamic named range, see this link for help on the topic.