I am working on a program that uses the distance formula.
Example:
=SQRT((B8-B7)^2+(C8-C7)^2)

I need to find a way to substitute variables for the cell locations.
B C
X and Y
7. 64.4 25.5
8. 65.4 24.9
9. 73.6 23.5
10. 39.5 96
11. 19.5 33.6
12. 25.5 98

Reference X and Y
12.2 13.6

The Loop im trying to create will take the Reference X and Y and plu
it into the distance equation along with the first X and Y in the char
which is B7 and C7. That result will be outputed. The program with the
take the next X and Y in the chart and calculate it with the sam
reference. this loop with continue until it reaches the end of th
chart.

If anyone has any suggestions on how to do this please let me know.

Thanks
Nic

--
Message posted from http://www.ExcelForum.com