I have got a sheet, in which I have got a dynamic number of columns with a number of dynamic rows.
It is a database export where I have got table names (headers) in each column and among them there are dynamic numbers of strings (attributes) which are not alphabetically sorted yet. I don't know how exactly to sort them with a vba script. I need this, because I want all columns as named ranges for dynamic dropdown lists.
I have seen a few possible solutions but I don't want to select manually ranges. This should work without any user interaction - just by calling this sub in another script.
I appreciate your suggestions.