» 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:
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Getting to Yes: Negotiating Agreement Without Giving In
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Microsoft PowerPoint Version 2002 Step by Step
No comments have been submitted.
