Copy 1000 columns

**Duncan1** · 01-09-2007, 01:40 AM

In Sheet1, I have 1000 columns with data from A1:A100 to ALL1:All100. I want to copy each indivdual column and paste into one colunm in Sheet2. Thank you.

**VBA Noob** · 01-09-2007, 03:24 AM

Hi,

Your post is unclear.

Sheet1, I have 1000 columns with data from A1:A100 to ALL1:100

1). A sheet only has 256 Columns
2) ALL1:100 is not a range.

VBA Noob

**mudraker** · 01-09-2007, 04:21 AM

VBA Noob

Would Duncan1 be using Excel 2007 which i understand has

1 million rows and 16000 columns

Never seen Excel 2007 so I do not know the exact specs - only what I have read & heard

**VBA Noob** · 01-09-2007, 07:25 AM

Hi mudraker,

Didn't know that.

Thanks for the info

VBA Noob

**Duncan1** · 01-09-2007, 07:59 AM

Yes, I am using Excel 2007 and the range ALL1:100 is a typo it should have been All1:all100. But the problem that I am having can be applied to 256 columns.