Just a thought, but if you use the macro recorder to see what the code is for
copy then pasting a whole column, you should be able to build up from there i
think.

This is what I got for moving one column and INSERTING it (rather than
pasting over another column) somewhere else:

Columns("C:C").Select
Selection.Copy
Columns("D:D").Select
Selection.Insert Shift:=xlToRight

If you put play around with that I think you should find one way of doing
it, maybe not the best tho

"Chandrasekaran P" wrote:

Hi,

i downloading datas as CSV format,then i restore as XLSX extention.I want to
whether possible to reorder the columns while downloading else how can i
rearrange the columns through macro's.