» 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:
- Special Edition Using Microsoft Access 2002
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Dictionary of Finance and Investment Terms
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
No comments have been submitted.
