I cannot identify the problem. I would suggest you set  a
breakpoint on the instruction and run  the macro. When it stops, go into debug
and look at what the target is, what its contents  are, etc.

I am assuming protection is turned off for the worksheet at this point. If it
is turned on, you may need to turn it off before the instruction and on again
afterwards.