Macro to retrieve and insert columns
Posted by Stanley on November 15, 2001 6:42 AM
Worksheet named "Financials" is protected. Need a macro which will:
1) Insert two new columns at whatever cell is selected when the macro is activated.
2) Activated another worksheet (named "Ranges") in the same spreadsheet,select columns K and L, and copy them
3) Paste Special/All onto the two new columns inserted in "Financials"
4) Deselect columns K and L in "Ranges" (don't care where the cursor ends up)
5) Select the cell on row 7 of the leftmost of the two columns inserted in "Financials"
Any help will be appreciated