hello all...i found this code and would like to know the following:

ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address & " / " & _
ActiveCell.Offset(-1, -1).Address

is there anyway to make one of the cells in the formula relative and
not absolute?

the result of this formula is (ie) "=$A$1/$B$1" and i'd like it to be
something like "=A$1 / $B$1"

Thanks!