Invalid Qualifier

Hello, and welcome to the forum.

Bad things first - can you please read the forum rules and use code tags around any code you post.

On to the problem - what are you trying to do with the .length property? The variable arr isn't an object, but an array. If you want to know how many elements there are in the array and loop through them then what you need is:

Please Login or Register  to view this content.

Hope this helps.

Many thanks,
I'm sorry for the code tags, I'll read the rules before posting another code.

I've ament the code with your suggestion, but unfortunately it doesn't work. Now I have a "Run-time error: 1004. Application defined or object-defined error." on "Cells(i + 12, zeta) = arr(zeta)".
I would loop through the elements in a single row before going on next column.
Thanks in advance.

After I posted I realised that would be your next problem and meant to warn you about it.

The issue is that, by default, Excel arrays run from element 0, not element 1.

The quick and dirty way to fix this is, right at the start of your code - even before the "Private Sub" line put:

Please Login or Register  to view this content.

This is fairly sloppy programming practice, but will work just fine in this case.

The 'proper' way of doing it would be something like:

Please Login or Register  to view this content.

Now it works, many many thanks!!!!

Luca