Tip Printed from ExcelTip.com
Change range with more then Area to values using VBA in Microsoft Excel

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



Sub Values_4()
    Dim smallrng As Range
    For Each smallrng In Range("a1:c10,e12:g17").Areas
        smallrng.Value = smallrng.Value
    Next
End Sub