PDA

View Full Version : Chart Height adjustment not working!



mike.magill
07-11-2017, 10:59 AM
This is a snippet of a larger piece of code that worked fine a few months ago but now does not. The Chart Heights are not altered at all by this loop. The variable ChrtHeight is set as a Double and is given a value of about 820 compared to the existing height of roughly 46.

Why isn't it working now? What has changed?


For Each Chrt In SummSht.ChartObjects
ChrtHeight = (45.6 * Application.WorksheetFunction.Max(UBound(FileNameArray) - ErrorCount, 1)) + 0.04
Chrt.Height = ChrtHeight
Next Chrt