Tip Printed from ExcelTip.com
Change the selection with one or more areas to Values using VBA in Microsoft Excel

VBA macro tip contributed by Ron de Bruin, Microsoft MVP - Excel 



Sub Values_10()
    Dim smallrng As Range
    For Each smallrng In Selection.Areas
        smallrng.Value = smallrng.Value
    Next
End Sub