Hi

set up an area of the worksheet to be where your users input the cell
references they want to use
i've chosen A11:A14
then change the formula as follows

=SQRT((INDIRECT(A11)-INDIRECT(A12))^2+(INDIRECT(A13)-INDIRECT(A14))^2)

Regards
JulieD

"woknick " wrote in message
...
How can change the cell locations within a formula. Here is my formula

=SQRT((B8-B7)^2+(C8-C7)^2)

I want to be able to substitute user inputs for the B7,B8,C7, and C8.

Please let me know how to change those locations to variables.

thanks in advance


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