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,

Recommended Answers

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.

Jump to Post

All 2 Replies

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 learning and sharing knowledge.