No but VBA has a ConvertFormula method. Check that out in help.

--

HTH

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


"Sharon" wrote in message
...
Hi there,

I know to toggle between relative and absolute value references to use F4.
However, I have copied and pasted a relative formula across several
columns
and down several hundred rows.

Can I select the entire range and change all the formulas to absolute
references without clicking in every single cell? (Cell range is
BB3:BQ400)

Thanks,

Sharon