How can create an absolute reference on a group of cells

Use the '$' character. E.g., $A$1:$C$10

Note, though, this will change if you insert rows in 1:10. You can also use
INDIRECT("A1:C10") which prevents Excel from changing the reference when a
row in inserted.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)



"ab" <(E-Mail Removed)> wrote in message
news:AA5A1061-D865-4E1B-B8FB-(E-Mail Removed)...
> How can create an absolute reference on a group of cells
>

For a range of cells you could use a macro to change all at once.

Sub Absolute()
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula _
(cell.Formula, xlA1, xlA1, xlAbsolute)
End If
Next
End Sub


Gord Dibben MS Excel MVP

On Tue, 5 Jun 2007 09:32:20 -0500, "ab" <(E-Mail Removed)> wrote:

>How can create an absolute reference on a group of cells
>