| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why do I get an error message when i try to merge cells? | Excel Worksheet Functions | |||
| Error message: Too many different formats of cells | Setting up and Configuration of Excel | |||
| Too many formatted cells error message | Excel Discussion (Misc queries) | |||
| VBA-Error Message Assistance Needed | Excel Programming | |||
| How to sum a row of cells containing an error message to overlook | Excel Worksheet Functions | |||
Linear Mode
