Good Morning all,
I have a workbook with multiple worksheets. Within each worksheet is a column heading named "CurrencyDesc" (located in a different column in each sheet, and that will always change). I want to find "CurrencyDesc" and insert a column to the right of it. I have part of the code, but it only applies it to the first worksheet.
ActiveWorkbook.Sheets.Select
Selection.EntireColumn.Select
Cells.Find("CurrencyDesc").Select
ActiveCell.EntireColumn.Offset(0, 1).Insert
I need it to apply the find and insert to ALL of the worksheets. What am I missing?
THANK YOU IN ADVANCE!!!
I have a workbook with multiple worksheets. Within each worksheet is a column heading named "CurrencyDesc" (located in a different column in each sheet, and that will always change). I want to find "CurrencyDesc" and insert a column to the right of it. I have part of the code, but it only applies it to the first worksheet.
ActiveWorkbook.Sheets.Select
Selection.EntireColumn.Select
Cells.Find("CurrencyDesc").Select
ActiveCell.EntireColumn.Offset(0, 1).Insert
I need it to apply the find and insert to ALL of the worksheets. What am I missing?
THANK YOU IN ADVANCE!!!
