- Apr 23, 2011
Cells are copied vertically (in a column) in one workbook. There is an option to insert copied cells. The only option is shift cells down or right. I want to insert cells horizontally (in a row). This is something similar to paste special: transpose. The paste special: transpose doesn't work as cells contains images. Is there way out either manually or through vba?