Discussion Locked

Excel Absolute cell reference conversion

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I convert a whole cell selection to absolute references without having to go through each cell separately please.

1 reply

by dklippert

Here's a macro. Select the cells and then run it.
Sub Change_to_ABS()
Dim Cell As Range
Set Cell = Selection
Cell.Formula = Application.ConvertFormula _
(Cell.Formula, xlA1, xlA1, xlAbsolute)
End Sub

This discussion is closed to new replies.