I am trying to manipulate a named range ("CompetitorShareOption") of 1 column
x 6 rows in VBA. I have declared the array (Dim CompetitorOptionsArray as
Range), and am bringing it into VBA with the line:

Set CompetitorOptionsArray = Range("CompetitorShareOption")

However, when I try to write the back again to the named range with the line:

Range("CompetitorShareOption").Value = CompetitorOptionsArray

the named range becomes blank, despite there being values in the array. I
get the same thing happen if I define the range by their cell labels.

Thanks in advance,

IanC