|  

» 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


Rate This Tip
12 34 5
Rating: 2.14     Views: 21340
No comments have been submitted.
Name
Comment Title
Comments