Transpose Rows in Columns in MS XLS using VBA

Question

I have an XLS for which I need to A1:H1 to say A1:A7. I can achieve this by using the transpose function in copy. However I need to do this as part of VBA script. I don't seem to find any equivalent function.

GSerg · Accepted Answer · 2010-10-18 11:29:35Z

2

Same, basically.

You can use Copy:

source_range.Copy
dest_range.PasteSpecial Transpose:=true
application.cutcopymode = false

Or you can avoid using it (if you only need raw values):

dest_range.value = application.worksheetfunction.transpose(source_range.value)

answered Oct 18, 2010 at 11:29

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Transpose Rows in Columns in MS XLS using VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related