Thread: Array to copy columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
  
Posts: 65
Default Array to copy columns
I found this code but the order of columns remains A,B,C


myarray = "B:B,A:A,C:C"
Worksheets("Sheet1").Range(myarray).Copy Worksheets("Sheet2").Range("A1")


FIRSTROUNDKO wrote:
Hi,

I would like to copy from Sheet1 Columns B ,A, C in that order

to

Sheet 2 Columns A , B, C

can this be done by array

i.e myarray(B,A,C)

Thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201005/1

Reply With QuoteReply With Quote