1. Are there data in Sheet "17AE" range M3:M42 as defined by the formula:
"='17AE'!R3C13:R42C13"

2. Are there data in the X-Values range as defined by the code you listed ?

3. Is the worksheet actually spelled "17AE" (i.e. no spaces) ?

What I think is likely happening is that once one of the series foumula
lists an invalid reference then you are in a cul-de-sac and can't
programmatically change it. If you first manually correct the formula(s) and
then run the code it might work.

If not successful feel free to email me a copy of the project and I can have
a look. I suggest that you delete any unnecessary sheets & data and just send
a simplified version that still exhibits the problem.

Remove the text "SpammersDie!!!" from the following address:


Regards,
Greg


"Ken Kazinski" wrote:

Hi Greg,

I really appreciate the help. I have changed the code in a number of ways
and each time when I try to set the xvalue I get the error.

.XValues = oSheet.Range(Cells(3, Col_M), Cells(RowNo - 1, Col_M))

I have global constants for all the Col_(letter) variables.

I checked for protection or locked cells and I can not find any.

Ken