https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65779#M18384 Hello,   Please try range.RemoveDuplicates Columns:=Array(1, 2), Header:=1   Joshua Thu, 10 Jan 2019 18:03:00 GMT JoshuaKingsley 2019-01-10T18:03:00Z https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65778#M18383 Hi everyone. I am trying to create RemoveDuplicates Excel VBO and having troubles with the code   ------------------------------------------------- Dim wb, ws As Object Dim excel, sheet, range As Object   Try   wb = GetWorkbook(Handle, Workbook) ws = GetWorksheet(Handle, Workbook, Worksheet)   wb.Activate() ws.Activate() excel = ws.Application sheet = excel.ActiveSheet range = sheet.Range(Reference)   range.RemoveDuplicates(Columns:=Array(1, 2), Header:=1)   Success = True   Catch e As Exception Success = False Message = e.Message Finally wb = Nothing ws = Nothing excel = Nothing sheet = Nothing range = Nothing End Try ---------------------   I get an error on "Array(1,2)", description saying compiler error. If anyone could provide advice, I would be really grateful.   Thanks. Thu, 10 Jan 2019 06:23:00 GMT https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65778#M18383 KoogunNa 2019-01-10T06:23:00Z https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65779#M18384 Hello,   Please try range.RemoveDuplicates Columns:=Array(1, 2), Header:=1   Joshua Thu, 10 Jan 2019 18:03:00 GMT https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65779#M18384 JoshuaKingsley 2019-01-10T18:03:00Z https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65780#M18385 Hi Joshua, I think Blueprism can not be able to deal with this code.   Does anyone know how to deal with the Array? Datatype:String can not be converted to Array in blueprism.   Tsai Thu, 24 Jan 2019 09:28:00 GMT https://community.blueprism.com/t5/Product-Forum/RemoveDuplicates-Excel-VBO-help/m-p/65780#M18385 Anonymous 2019-01-24T09:28:00Z