Macro Modify to Include X-Axis

[comp]

Hey guys, I have a macro that will change the font size of every Y-Axis on the chart on the active sheet. It works wonderfully, but I also need to include the X-Axis as well. Is there a way to make this change the font size of both X and Y Axis?

Please Login or Register  to view this content.

[MrShorty]

Simply add another With block that works on the cht.axes(xlcategory).... object. https://msdn.microsoft.com/en-us/lib.../ff821055.aspx

[comp]

i tried this, but it says "For Control variable already in use"

can someone provide an example of a correctly modified macro?

Please Login or Register  to view this content.

[MrShorty]

And the error is exactly right -- you are trying to nest a For each sht..Next sht loop within another For each sht..Next sht loop.

Please Login or Register  to view this content.

As noted in teh code, I'm not sure why you are looping through the shts twice. I would loop through the sheets and chart objects once, and modify both axes during each loop.

[comp]

I appreciate the help, but I do not know how to write macros very well, and I tried running that and came up with the same issue. Can someone please help with an example of something that i can run?

[MrShorty]

Please Login or Register  to view this content.