I am constantly importing excel files into access. The problem im having is the top row of every column
does not contain the column headers, the 2nd row does. I want to create a macro that will delete the top row of every sheet
in my workbook.
I was thinking of writing a looping macro but im not sure how to do it.
To delete the
1st column in the active worksheet this is the macro:
' Macro2 Macro
So now i need to loop this so it does 15 sheets, preferrably not based on the name of the sheet itself so i can
run it in different work books.. Any suggestions?
I just realized i can CTRL and select multiple all the
worksheets, but I think if i didnt have to do that it would still save time.