Hello, I made a script that summarizes a table - in one part, it is set to remove duplicates but it's asking which column to use as a basis. I read that it's a bug in Excel for Mac, just wondering if there is a workaround. And whenever I paste a data from another excel to the first sheet of my file, a pop-up shows saying "The Maximum number of data series per chart is 255" - I'm using manual paste Ctrl+V and selecting only one cell (approx 20rows by 6 columns

Columns("E:L").Select
Selection.delete Shift:=xlToLeft
Columns("A:D").Select
ActiveSheet.Range("$A$1:$D$1000").RemoveDuplicates Columns:=Array(3, 4), _
Header:=xlYes
Range("E1").Select••••ˇˇˇˇ∫lâ”…[◊ îà©ÿ¥ï◊é T#

Thanks!