HI,
I need to insert a 2 new Columns into an existing worksheet but they have to fit in the correct place alphabetically.
I've got an input box that get the new Column's Title, but at the moment I can only add it to the next blank column at the end.
I need code that will take the input box text and check it against all the colums then insert a new colum in the right aphabetical place.
Here's the code I'm using which adds two columns at the end and formats them correctly.
![]()
Please Login or Register to view this content.
Bookmarks