Using VBA for loop to reference data in another file

[Fnurgg]

Hi,

i'm just taking my first steps in excel VBA and i'm stuck with the following problem: i'm writing a for loop to copy data from one document to a new one. (in the future i'll want to put the data from multiple files & colums in 1 single column) but using the code below results in an error. Weird thing is: when i type the exact same formula manually into a cell (and replace i with a value ofc) i get the result i want...

Am i missing something?

Thanks in advance
Jo

Please Login or Register  to view this content.

[shg]

It's not an R1C1 formula:

Please Login or Register  to view this content.