Incremental copy paste

[BrandonSanchez]

@Jfish starting the loop at $i=1 to $lastRow gives me the same results.

I hope that I’m explaining it correctly. I can't seem to get the _ArrayToClip to move down the list of the array after each cycle of $i.

(Example: first cycle of $i=0, this would take “Test1” and place it into the clipboard where the rest of my code will run. $i=1 will take “2” and place it into the clipboard where the rest of my code will run, and so on until $lastRow)

Thank you for the help and I apologize if my explanation is confusing or just off

[Jfish]

I can't see what is happening in your whole for loop.  Can you post all your code?  Also, could you please use the code tags <> instead of an image?

[BrandonSanchez]

I figured it out @Jfish the issue that i had was _ArrayToClip had the wrong parameters. I changed it from 

_ArrayToClip($aResult,"", Default,0, $lastRow)

to

_ArrayToClip($aResult,"",$i,$i)

and it now goes down the array one row at a time during my loop. 

Thank you again for all of your assistance and patience. 

[water]

On 18.4.2016 at 7:16 PM, Jfish said:

@water I did not notice $xlUp in the excel constants.  I know you could probably fill that file to a crazy size if you added everything but wondering if would consider adding it?

Only constant enumerations used in the UDF have been added to the ExcelConstants.au3 file. That's to not bloat the UDF and not to interfere with other UDFs (like ExcelChart).
But you can always create your own UDF with often used constants not contained in other UDFs