I have a spreadsheet such that when the user clicks on a button (attached to
a macro), it manipulates the data and inserts columns at specific points.
However, there is a conflict in the process because at one point it says to
select Column K (to insert another column), and I get an error because in the
module for that sheet under Worksheet_Change is a macro that runs whenever
any cell in Column K is selected. Is there a way to get around this, other
than rearranging the format of the spreadsheet itself?