It works for me. Send me your workbook if you would like and I'll see if I
can repeat the error.
--
Charles Chickering

"A good example is twice the value of good advice."


"Barb Reinhardt" wrote:

No, it's a worksheet. Any other suggestions?

"Charles Chickering" wrote:

Is the ActiveSheet a chart?
--
Charles Chickering

"A good example is twice the value of good advice."


"Barb Reinhardt" wrote:

I have the following

Set myRange = Cells(9, 3) .Resize(52,31)

I got the error method cells of global object failed.

Can someone explain why it's not working?

Thanks