Copy/Paste Range doesn't work

[ibnu.alem]

Hi, I need to copy row from Sheet A to Sheet B,
there’s no syntax error, no exception. the Sheet B is successfuly created automaticaly but there’s nothing pasted,
I inputted Currentrow in Source box
and mainExcel.Sheet(“SheetB”).Range(“A1:Q1”)

I need to copy color and format in that row beside the value, so I think I can’t pass it using datatable(?)

[lrtetala (Lakshman Reddy)]

Hi @ibnu.alem

If you want to copy the sheet then try this

[ibnu.alem]

No, I need to copy specific row from for each row after some selections.

but nvm haha turns out the “Exclude Header” is supposed to be “Exclude Header from source table only”

thanks for your response