What to key in under Delete Rows?

[weelearns]

Hi, I am trying to remove the first 4 rows of an excel and cant figure out what to put under the delete rows – in what table or range.

Excel Application Scope (Delete Rows) works for me but I can’t use it as I have another vlookup (use Excel file) at the bottom of this process. I will receive an error “For Each Excel Row: COM object that has been separated from its underlying RCW cannot be used” if excel application scope and use excel file functions are being used together.

[supermanPunch (Arpan)]

Hi @weelearns ,

Could you simply try to use the Sheet name in the below way :

Excel.Sheet("Sheet name")