» 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
CATEGORY - Cells, Ranges, Rows, and Columns in VBA
VERSION - All Microsoft Excel Versions
Sub Values_2()
With ActiveCell.CurrentRegion
.Value = .Value
End With
End Sub
Book Store:
Recommended Books:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Getting to Yes: Negotiating Agreement Without Giving In
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Finance and Accounting for Nonfinancial Managers
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Writing Excel Macros with VBA, 2nd Edition
No comments have been submitted.
