I have a macro set up in Excel that imports data from
other Excel files and then edits the data accordingly in
various sheets. There are 20 sheets in this Excel file.
If I need to edit the Excel file so that I delete a sheet
or add a sheet, what is the best way to edit the macro in
VBA? For example, is there any way to search for all of
the actions in the programming that pertain to a certain
sheet and automatically delete them? Thanks:)