Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart.
Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are plotted in thesame graph.
Thanks,

This does not belong in the vb.net forum. I've moved it up to the Software Development level and added appropriate tags for searching.

When you can avoid VBA macros, avoid them. Excel has a great set of worksheetfunctions, among them : MAX and INTERCEPT. Hope it helps.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.