One code VBA To calculate the slope of the line and the distance between two lines on

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

I marked the red line in the photo
Line number ten and fifteen How is the slope of these two lines calculated? Then how the distance between two lines is calculated

I sent you an example of an Excel file containing the chart

Thanks a lot

Hello my friend .I posted the file in the forum please help me

Post the workbook HERE in this thread - attach it to your next post. Your other, duplicate thread has been closed.

Hello my friend . My question is how to calculate the slope of the line and the distance between two lines in the Excel chart

I asked you for the workbook. Is it the one you attached to post #4?

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks

Perhaps there's some language problem here. I'm a VBA novice but I don't think you will get a solution from anyone until you provide more information:

1. The lines' co-ordinate data, not just an image. Any two points on the line (x1,y1) and (x2,y2) will define it.

2. Clarify what you mean by "...the distance between the two lines". This is not a constant. It depends on which two points you choose as its start and end.

3. And "...to calculate the slope of line number ten and fifteen" do you mean you want the angle between these two? Or do you want two angles, one for each line? In which case between which axis, x or y? Measured in which direction, clockwise or anti clockwise?

With that data, I think a VBA expert could write a VBA sub using the appropriate trigonometry!