Is cell value assigned to variable?

[mikeymay]

Is there a way od checking if a value in a cell is already assigned to a variable when using a dynamic array?

E.g.
Cells A1-A3 contain the text "Red"
Call A2 contains the text "Blue"

strColour1 is assigned the value "Red"
strColour2 is assigned the value "Blue"

As A3 which contains "Red" is already assigned, then this is ignored.


Thanks