Excel VBA: change marker styles for all series excluding unmarked lines

[sonofamonkey10]

I have a macro that changes the marker style for all series in a scatter chart, chosen through an input box.

Please Login or Register  to view this content.

It works nicely, but I want it to exclude any series that do not have markers (i.e. lines used to indicate a reference value). I've tried an if-then statement after the With statement, but it will add markers to any line series:

Please Login or Register  to view this content.

Basically, if the series has markers or line+markers, I want it to change the marker style, otherwise do nothing with the series.
Any suggestions?

[xladept]

How about:

Please Login or Register  to view this content.

With no "End If" required

[sonofamonkey10]

xladept,

thanks for the reply, but your suggestion didn't change anything. the series with plain lines still get converted to line+markers. (btw, all series are XY scatter).

I will upload a snapshot and example workbook later when my computer lets me.

[xladept]

'Til then then

[sonofamonkey10]

well, I think I resolved my issue; the .MarkerStyle syntax just needed a slight modification. Now, it will only modify series that have markers.

Please Login or Register  to view this content.

Thanks for giving it a look!

[xladept]

Great - glad you figured it out! (You could still do it without the "End If" though)