Problem with _ExcelPaste

[CongTin]

Dear all,

I am a AutoIT newcomer.

Thanks for your time.

Could you please support me how to solve this issue as belows?

I use _ExcelCopy to copy one cell.

After that, I use _ExcelPaste to paste the clipboard to a range of cells from cell A2 to cell A$i which $i is a variable.

I try to write _ExcelPaste($otest,A2:A$i) or _ExcelPaste($otest,"A2:A$i") but it dont work.

Please help me.

Thank you so much,

Regards,

CongTin

[enaiman]

"A2:A"&$i

You have to "tell" AutoIt that $i is a variable.

Whatever is between quotation marks is regarded as text.

[CongTin]

"A2:A"&$i

You have to "tell" AutoIt that $i is a variable.

Whatever is between quotation marks is regarded as text.

Dear Enaiman,

You are great,

It works now. Thank you so much.

It sound very simple but I cannot figure out.

Thank you again,

Warm regards,