jdgalaway
03-06-2013, 10:24 AM
First, I am pretty new to VBA so this may be stupid easy, but I hope someone can help.
We have a macro and the person who wrote the code no longer works for us. I'm trying to use my limited VBA knowledge to edit it.
The macro imports data into excel from a folder containing several other spreadsheets.
After the code is done importing the data, I want to simply insert a column. I used the following code, but it just isn't working. If someone could please help me out, I would appreciate it.
Public Static Sub insertColumn(ByRef Sheets As Sheets)
Worksheets("Summary").Range("AJ1").EntireColumn.Insert
End Sub
We have a macro and the person who wrote the code no longer works for us. I'm trying to use my limited VBA knowledge to edit it.
The macro imports data into excel from a folder containing several other spreadsheets.
After the code is done importing the data, I want to simply insert a column. I used the following code, but it just isn't working. If someone could please help me out, I would appreciate it.
Public Static Sub insertColumn(ByRef Sheets As Sheets)
Worksheets("Summary").Range("AJ1").EntireColumn.Insert
End Sub