Hello, I'm trying to create a loop which selects data in multipl
worksheets and pastes it into another sheet. It would be doing tw
columns at a time. In other word, the first iteration would be pastin
to columns 1-2, the 2nd 3-4, 3rd 5-6, etc. However, Excel uses letter
for their column headers. How can can I tell it to increment the colum
on every iteration of the loop?

Below is a (probably bad) illustration of what I want to do:
Worksheet
Code
-------------------
AA
AA
A
-------------------
+Worksheet
Code
-------------------
BB
BB
B
-------------------
+Worksheet
Code
-------------------
CC
CC
C
-------------------
=Different Shee
Code
-------------------
AABBCC
AABBCC
AABBC
-------------------


--
Message posted from http://www.ExcelForum.com