Sorry premature send!
The code is
Public Sub MyConvertFormulas()
Dim oRange As Range
Dim c as Range
Set oRange = Selection
for each c in oRange
c.Formula = Application.ConvertFormula(Formula:=c.Formula, _
fromreferencestyle:=Application.ReferenceStyle,
toabsolute:=xlAbsolute)
Next c
The main issue is where the references point. If they are pointing within
the block you are copying, there is no issue as they will continue to point
to the appropriate cells within the block. If they are to another sheet
and the block is pasted in a different starting position (same or other
she
Hi, I have a spreadsheet with large areas of cells that do not have anchors
in the formuals. In other words, the content of a cell would for example
show =A1 instead of =$A$1
I need to copy this block of cells to a another location (not move, I
understand this works with cut/paste) where I w
