A VBA Function to sort tables based upon a column header

I am still new to Excel VBA and albeit I can get most things to work I am sure there is a better way to do it.
In this example I have created a function to sort my workbook sheets based upon a table column header.
What I really wanted to do was create a function where I could pass the sheet name, table name and column header
into the function, but I just could not get the range correct for the sort key, so I ended up creating a function
where I just passed the sheet name down and used an if statement for all my sheets in the workbook.
The problem with this is I can only ever sort the using a set column in my sheets and if I add another table, I will have to remember
to change the function.

Can anyone help me to reach my goal and get rid of the if statements?

Please Login or Register  to view this content.

Thanks

you're going to have to use an array, more than likely, in the arg of the function, to get what you want. everything else should be smooth sailing. but then again, your LO names also change. so, either you'll have to loop your sheets to grab those names, or put them into an array as well. it really depends on how you have this set up. this would be a starting point for you:

Please Login or Register  to view this content.

that's only a guess by me. most things can be concatenated in like this, although there are exceptions to the rule.

Thanks, AlphaFrog just what I wanted. Worked first time.

Thanks for your help, but I have gone with AlphaFrog's suggestion.