» Change all the cells in the ActiveSheet 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_1()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub
Book Store:
Recommended Books:
- Microsoft Windows XP Registry Guide
- Getting to Yes: Negotiating Agreement Without Giving In
- How to Read A Financial Report
- Microsoft Excel VBA Programming for the Absolute Beginner
- Analyzing Markets, Products, and Marketing Plans
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
