Hello,
I'm a VBA beginner and I've tried the macro recording but it uses the
activesheet. The examples I've found use named and/or contiguous ranges.
They are not specific enough or too complicated, using arrays. Even though
there is more code by explicitly programming, it is very clear.

In an open workbook, Beginning at Sheet4 I need to add

33 tabs,
name each tab
create a line chart, no markers, on each tab
insert 9 series with different colours,
preferably specify dashes/dots, thickness etc.
specify the data range for series each as six not contiguous cells
chart title
y axis title
x axis labels
specify chart size - to fit on one landscape page

Could someone please program the first two tabs and charts and I'll copy and
fill in the rest or direct me to somewhere that does something comparable.

Thanks in advance,
John