Excel array copy paste loop

[Gintaras]

Macro Macro3204

Code:

Copy      Help

ExcelSheet es.Init
ARRAY(str) a
es.CellsToArray(a "sel") ;;get the selected cells. Or you can use a column/row/range definition; see examples.
int row
for row 0 a.len
,str s=a[0 row]
,OnScreenDisplay F"Row {row+1}. Press Down to paste."
,wait 0 KF D
,OsdHide
,key H SE ;;if field text not empty, select it to replace
,paste s
OnScreenDisplay "Done"


#ret
area for testing