I would greatly appreciate your help on this, because I am going crazy.
I have a spreadsheet
filled with data (no merged cells) and I created a macro to sort the spreadsheet. Everything was working perfectly, until I
tried to insert a column using code at the beginning of the macro.
The code is
When the macro now runs, the first row acts as if a column has been inserted, i.e it shifts to the right, but the remainder
of the spreadsheet does not.
I've tried shifting data to a new sheet, creating a new module, inserting another
column, nothing works!!! However, if I step-into the macro, after stepping over the code once (where it does as above), when
I shift the cursor above the code and step over it again, it inserts the column!
This is driving me to
distraction, any thoughts or help would be greatly appreciated!!