TrustedHippo
New Member
- Joined
- Nov 11, 2020
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
I am trying to create a vba script to calculate distance between points (specifically line length) in a given section (ie: from x=2 to x=5 and so on) the section will be defined in a cell inside the workbook so it can be changed on the fly.
This is how my data points are set up, row 1 is a start point and row 2 is the end point on a line, row 3 is a start point and row 4 is an end point on a line and so on and so on. I'm not quite sure where to start besides long hand finding the distances with cell formulas and repeating. Kinda new to vba macros..
0.000000 | 1.000000 |
-0.027735 | 0.958398 |
0.000000 | 2.000000 |
0.027735 | 1.958398 |
0.000000 | 3.000000 |
-0.027735 | 2.958397 |
0.000000 | 4.000000 |
This is how my data points are set up, row 1 is a start point and row 2 is the end point on a line, row 3 is a start point and row 4 is an end point on a line and so on and so on. I'm not quite sure where to start besides long hand finding the distances with cell formulas and repeating. Kinda new to vba macros..