Array of Booleans from Excel to VBA

  • Hi all,

    I'm trying to read an array of True/False values from a named range in Excel into VBA. I can only get this to work if I declare the variable "comparators" as a variant, but this doesn't work if I declare it as a boolean type. My question is..why?


Participate now!

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