Excel adding 1 to the cell value

[SerHenning]

Hey, I'm trying to do a process which involves copying a cell from Excel, then repeat that process but copying the next cell and so on. Is there any simple way to do that? I got my entire paste process and I can copy one cell, which I wrote down, e.g. A1 and now I want to copy A2, A3 and so on. I think I gotta make the cell value a variable but I'm pretty sure its more than that, as it got an A in front of it. Ignore my way of opening the editor please  🤣

#include <IE.au3>

#include <Excel.au3>
#include <MsgBoxConstants.au3>

Local $var = "C:\Users\Jan\Documents\Projekte\Autoitlernen\excel\testitest.xlsx"
Local $oExcel_1 = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel_1, $var)
Local $_read = _Excel_RangeCopyPaste($oWorkbook.Activesheet, "A2")

send ("{LWIN}")
Sleep (1000)
send ("e")
Sleep (200)
send ("d")
Sleep (200)
send ("i")
Sleep (200)
send ("{ENTER}")
Sleep (1000)

 

[Subz]

Use RangeRead

[water]

You could simply read the whole column in one go and then retrieve A1, A2 ... from the returned array.