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