Check/Compare Array Elements

  • I have an array that is created by loading a range from a workbook into a variant. When I try and validate the data (by checking if it matches either of two strings - see commented error line below) in the array globaldataarray I get "Run Time Error '13' Type mismatch".

    The column of data in question has a column heading (excluded by starting at row 2) and according to the quick pivot table I ran on it, to see the unique entries, contained only blanks, single letters and 3 letter strings.

    I get the same error when trying to do the same thing on a column of numbers (decimal an integer) produced by a formula in that column.

    Any ideas thoughts or suggestions much appreciated.

    In a separate module;

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!