Please attached Your Sample WOrksheet
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kat
Sent: Wednesday, June 08, 2011 6:49 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Excel Macro- source series for a chart
can you share you sample workbook of 2 or 3 sheets
On Wed, Jun 8, 2011 at 6:48 PM, Kat wrote:
> I'm sorry, I'm still not having any luck with this. I'm getting
> runtime error 91, object variable or With block not set.
>
> Does this mean that when you select the sheets you deselect your
> char
I'm sorry, I'm still not having any luck with this. I'm getting
runtime error 91, object variable or With block not set.
Does this mean that when you select the sheets you deselect your
chart? How do I best write the code within the loop so that I do not
get this error?
On Jun 6, 3:22 pm, ashish
Sub test()
For i = 1 To Sheets.Count
Sheets(i).Select
' paste ur code here
Next i
End Sub
On Mon, Jun 6, 2011 at 2:12 PM, Kat wrote:
> Hi all,
>
> I have a large spreadsheet, ~200 sheets. For each of these, I wish to
> plot a series where the x values are D3:D103 and the y values are
> E3:
Hi all,
I have a large spreadsheet, ~200 sheets. For each of these, I wish to
plot a series where the x values are D3:D103 and the y values are
E3:E103, and the series name is the same as that of the sheet, all on
the same chart.
So far I have
ActiveChart.SeriesCollection.NewSeries
Acti
