I
IanC
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
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