Assistance with error message on CELLS
 

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

Assistance with error message on CELLS
 

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

Assistance with error message on CELLS
 

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

Assistance with error message on CELLS
 

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

Assistance with error message on CELLS
 

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.
--
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

Assistance with error message on CELLS
 

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.
--
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

Assistance with error message on CELLS
 

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.
--
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

Assistance with error message on CELLS
 

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.
--
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

Assistance with error message on CELLS
 

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.
--
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