Dim Array as Non-Variant Generates Type Mismatch Error

[biocentrism]

Hello

I have the following code. When I Dim the array as a Variant it works. But when I Dim the array as Double, it generates a type mismatch error.

Can anyone shed light as to what I am doing wrong?

Thank you.

Dim arrPrice as Double '<----works if Variant datatype
arrPrice = Intersect(rngPriceCheck, Columns(colPrice)) '<--type mismatch error

 

[RoryA]

Assuming there's only one cell at the intersection add .value2 to the end of the Intersect line.