Tip Printed from ExcelTip.com
Change only the CurrentRegion of the ActiveCell to values using VBA in Microsoft Excel

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



Sub Values_2()
With ActiveCell.CurrentRegion
            .Value = .Value
        End With
End Sub