Finding Max/Min Values on a Graph

Hi all,

I have a set of data (voltage vs. time) and I need to find the a few points on my graph that correspond to the data in the column that it represents, so far with help, I have been able to determine my first point which is noted as V1T1. The other points that I need to find are noted on the attached picture. I'm sure it can be done in vba, and the reason why I am wanting to do this is to simply be able to use a command button and find all of these points on demand for future use in equations. As I mentioned before attached is a picture of the graph as well as my excel sheet and the code used to find the Max value on the first peak of the graph. Thanks in advance.

RTR97

Graph.png

Please Login or Register  to view this content.

Ok, another question about the code displayed above, could someone advise me on how I can get the cell address of the "dMaxVolt" variable to display in a MsgBox? Thanks.

The code below solves the second question. Thanks to me.

Please Login or Register  to view this content.

Please Login or Register  to view this content.