| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro error, range object need data?
Hi all
How can I improve my macro which has a macro error like below: "Macro error The method can't be used in the applied context. Specifically, some Range object methods require that the range contain data. If the range does not contain data, the method fails." How can I modify range object which has some empty data in the range? Thanks Daniel |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Macro error, range object need data?
Hi,
Does the range you are referencing contain data? Empty cells or those containing #N/A can cause problems when using the charting section of the object model. Cheers Andy Daniel wrote: Hi all How can I improve my macro which has a macro error like below: "Macro error The method can't be used in the applied context. Specifically, some Range object methods require that the range contain data. If the range does not contain data, the method fails." How can I modify range object which has some empty data in the range? Thanks Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
| Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
| runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
| Data, Group got error message Cannot shift object off sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
