Use of "Formula" prt2

[Ernesto]

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!

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ernesto]

perfect!

thanks!