Hi
why not put the following formula in D7:
=SQRT((B8-B7)^2+(C8-C7)^2)

-----Original Message-----
I am working on a program that uses the distance formula.
Example:
=SQRT(($E$1-B7)^2+($F$1-C7)^2)

and copy down. Where E1 and F1 store your reference values


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 plug
it into the distance equation along with the first X and
Y in the chart
which is B7 and C7. That result will be outputed. The
program with then
take the next X and Y in the chart and calculate it with
the same
reference. this loop with continue until it reaches the
end of the
chart.

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

Thanks
Nick


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

.