In vba, is there a way to assign a variable (variant datatype, array of integer values) to the Columns parameter of the Range.RemoveDuplicates method? I have searched many forums but have not found a solution that works for Excel 2007. Direct
assignments (e.g. Columns:=arrCols or Columns:=arrCols()) result in an error condition - generally an invalid procedure call or argument. Using the Evaluate method (Columns:=Evaluate(arrCols)) the procedure runs without generating an error but only the
first element of the array is used by the remove duplicates method.