manueslapera
05-18-2012, 12:12 PM
Hi!, I am pretty new to vba, and I am trying to write a macro that performs the following:
For every sheet in the workbook:
1. Select a column
2. Search in the selected column for a specific value in the Row number 5
3. If that value matches a word, then Insert two columns before the selected column
4. Perform the same for every column in the sheet. (i mean, those columns where there is something, I know that there are an infinite amount of potential columns).
Any help or direction toward an answer would be more than helpful. I could also upload a sample file if that helps.
For every sheet in the workbook:
1. Select a column
2. Search in the selected column for a specific value in the Row number 5
3. If that value matches a word, then Insert two columns before the selected column
4. Perform the same for every column in the sheet. (i mean, those columns where there is something, I know that there are an infinite amount of potential columns).
Any help or direction toward an answer would be more than helpful. I could also upload a sample file if that helps.