Turn on the macro recorder whilst you do these steps.

1. Select column B and hold SHIFT key.

2. Position cursor on the side of C1 then move to left of column F.

3. CopyPste SpecialValuesOKEsc.




On Wed, 30 May 2007 10:38:03 -0700, Letzdo_1t
wrote:

I'd like to move a column in between existing columns and possibly have the
results pasted as values. I've been searching through the posting but haven't
found anything I could use.

Would appreciate your help.

Thanks
James