Why the Excel Formula is Wrong

Hello Guys,

I want to know why the formula is wrong. Does anyone can help?

Hi @CHAN_Hiu_Fung_Victor_Stud

You can’t write the datatable to a single cell. Instead of giving like that, try the below one,

Excel.Sheet("FA controlC_(robot)").range("J1")

Hope it helps!!

@CHAN_Hiu_Fung_Victor_Stud

Try to use Range instead of cell

cheers

Instead of cell provide as Range and check