Determine Intersection of 2 lines using Excel VBA

  • Thread starter Thread starter velocityinc
  • Start date Start date
V

velocityinc

Y values - I have y-values in 2 rows of my spreadsheet, say A5:W5 and
A10:W10.

X values - The x-values are common to both rows, and listed in A2:W2.

I would like to use vba to determine the intersection of these y-
values, and determine where on the y-axis and x-axis do the lines
intersect.

I would like for the intercept to show up in a message box.

Could someone please assist with some vba code on this "intercept
analysis"

Thanks in advance.

V
 
Back
Top