i tried to read through each cell in a column in excel file and make another excel file to store the data.
-it works well without loop (only read and write the first cell)
-it works well until the cellReadNum = cellReadNum + 1 , i tried making a message box to print the cellReadNum value, it works well (2, 3, 4, 5…).
but when i connect the arrow to the “get cell value” box , it always read the same cellReadNum value which is 2 by default.
why is this happening ?? any help would be appreciated