Referencing columns by number in macro?

[jackjones123]

Hi,

I'm looking to pull the contents of multiple workbooks into one, and found this old thread, the first reply works perfectly:
https://www.mrexcel.com/forum/excel...file-folder-copy-data-into-open-workbook.html

However, that macro populates the summary sheet top-to-bottom whereas I want to populate it left-to-right, ie a new column for each workbook. So I need to reference the column by number.

I've tried changing rowTarget to iCol and changing ".Range("A" & rowTarget).Value = wsSource.Range("C2").Value" to ".Range(iCol & 1).Value = wsSource.Range("C2").Value" but not only does not populate, the macro just seems to open the first workbook and then do nothing. I've tried a few different variations but I'm getting nowhere.

Can anyone tell me what I need to do to make this work?

 

[Fluff]

Hi & welcome to MrExcel.

What cells do you want copy & where should they be copied to?

 

[steve the fish]

Hi. If you want to use a column number then maybe try cells method. eg for:

.Range("C2")

you could write

.Cells(2,3)

 

[jackjones123]

Hi. If you want to use a column number then maybe try cells method. eg for:

.Range("C2")

you could write

.Cells(2,3)

Thanks, that's exactly what I needed - I've just tested it and it's working perfectly, thank you!