Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
With statement help
So here's what i've got. I get a Run-time error '1004': Application-defined
or object-defined error on the marked statement. With Charts("FTCChart") .SeriesCollection(1).Name = "=RawData!$D$1" - .SeriesCollection(1).Values = _ Worksheets("RawData").Range(Cells(3, 6), Cells(a, 6)) End With Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
With statement help
Hi
Check if the "a" variable holds an integer number other than 0. Regards, Per On 29 Okt., 04:19, Brad wrote: So here's what i've got. I get a Run-time error '1004': Application-defined or object-defined error on the marked statement. * *With Charts("FTCChart") * * * * .SeriesCollection(1).Name = "=RawData!$D$1" - * * .SeriesCollection(1).Values = _ * * * * * * Worksheets("RawData").Range(Cells(3, 6), Cells(a, 6)) * * End With Please help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
With statement help
a = 16 in this case
"Per Jessen" wrote: Hi Check if the "a" variable holds an integer number other than 0. Regards, Per On 29 Okt., 04:19, Brad wrote: So here's what i've got. I get a Run-time error '1004': Application-defined or object-defined error on the marked statement. With Charts("FTCChart") .SeriesCollection(1).Name = "=RawData!$D$1" - .SeriesCollection(1).Values = _ Worksheets("RawData").Range(Cells(3, 6), Cells(a, 6)) End With Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |