plus_stick
07-03-2012, 02:13 AM
Hi all.
I have tables in Excel.
The names of the columns are on a separate row, such as: VA001, VA002, VA003 ... VA038, etc.
But there are cases where some names are missing, for example VA001, VA002 and then VA004.
Different ways in different tables.
I need to add empty columns in place of each missing number.
I have a code that does everything perfectly.
But the code works when the range of column names starts from the first column.
And I have a range starting from the fourth or fifth column, it does'n matter.
Example in attachment.
Please. Help me find a solution. Thanks in advance.
PS. Sorry for my english. I hope that everything is clear.
I have tables in Excel.
The names of the columns are on a separate row, such as: VA001, VA002, VA003 ... VA038, etc.
But there are cases where some names are missing, for example VA001, VA002 and then VA004.
Different ways in different tables.
I need to add empty columns in place of each missing number.
I have a code that does everything perfectly.
But the code works when the range of column names starts from the first column.
And I have a range starting from the fourth or fifth column, it does'n matter.
Example in attachment.
Please. Help me find a solution. Thanks in advance.
PS. Sorry for my english. I hope that everything is clear.