Dear Watersev,
Thanks thanks for your reply. It is so awesome. I don't think I can get better answer from forum.
Sub Absolute()
Dim cell As Range
With Application: .ScreenUpdating = 0: .Calculation = xlManual
For Each cell In Selection
If cell.HasFormula Then cell = Application.ConvertFormula(cell.Formula, xlA1, , xlAbsolute)
Next: .ScreenUpdating = 1: .Calculation = xlCalculationAutomatic: End With: End Sub
May I know which vba knowledge used in this macro (looping)? I tried to search in the web site, still can't get the solution. It seems that you develop the macro by yourself.
Bookmarks