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

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

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

It works for me. Send me your workbook if you would like and I'll see if I
can repeat the error. (E-Mail Removed)
--
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

I can't really do that. I do have an embedded chart above one of the cells.
I'll check to see if that's causing the problem.

"Charles Chickering" wrote:

> It works for me. Send me your workbook if you would like and I'll see if I
> can repeat the error. (E-Mail Removed)
> --
> 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

Well, it appears that was the problem, but I'm not sure why and I don't want
to change what I have. Any ideas?

"Charles Chickering" wrote:

> It works for me. Send me your workbook if you would like and I'll see if I
> can repeat the error. (E-Mail Removed)
> --
> 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

What do you mean by embedded? Is the chart selected when you run that line of
code? if so try activechart.deselect.
--
Charles Chickering

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


"Barb Reinhardt" wrote:

> Well, it appears that was the problem, but I'm not sure why and I don't want
> to change what I have. Any ideas?
>
> "Charles Chickering" wrote:
>
> > It works for me. Send me your workbook if you would like and I'll see if I
> > can repeat the error. (E-Mail Removed)
> > --
> > 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

Also, when in doubt I always specify the cells parent object if I'm not sure
what's selected:
Set myRange = Worksheets("Sheet1").Cells(9,3).Resize(52,31)
--
Charles Chickering

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


"Barb Reinhardt" wrote:

> Well, it appears that was the problem, but I'm not sure why and I don't want
> to change what I have. Any ideas?
>
> "Charles Chickering" wrote:
>
> > It works for me. Send me your workbook if you would like and I'll see if I
> > can repeat the error. (E-Mail Removed)
> > --
> > 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

Barb, did you find the problem?
--
Charles Chickering

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


"Barb Reinhardt" wrote:

> Well, it appears that was the problem, but I'm not sure why and I don't want
> to change what I have. Any ideas?
>
> "Charles Chickering" wrote:
>
> > It works for me. Send me your workbook if you would like and I'll see if I
> > can repeat the error. (E-Mail Removed)
> > --
> > 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