"Gina_Marano" wrote:

Hey Guys.

I want to paste a formula but I only want one of the cells to be
dynamic.

example (I am building a list of URLS)

A B
1 RootDir c:
2 file1.txt =HYPERLINK(CONCATENATE(B1,"\",A2))
3 file2.txt =HYPERLINK(CONCATENATE(B1,"\",A3))
4 file3.txt

I want the formual to alway refer to B1 and I want to iterate
A2...A(N). I am trying to cheat here because I have a lot of these to
do and don't want to keep having to edit the formula.

Any thoughts?

Gina_M


Put a "$" in front of B and another one between "B" and "1". That will
freeze B1 but allow your other reference to move around