Copy and Paste with Offset

Hi everyone! What code can be used to
1) insert a column 1 column position to the left of a specific cell (say a named range)
2) and then copy and paste the column values 12 columns away and paste it into the column that was inserted?
Thanks in advance!

Please Login or Register  to view this content.

Hi Walruseggman, thanks for the code.

I've tried it but it gives a "type mismatch" error. I'm not sure if the named ranges have to be defined as columns or will a single cell do? I'm defining the named ranges using Ctrl-F3.

Also to confirm that the code inserts the values into the new column rather than the column of the named range?

This. Replace "NamedRange" with the name of your range, and yes, it does need to be in quotes.

Please Login or Register  to view this content.