» 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:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Wall Street Journal Guide to Understanding Money and Investing
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Excel 2002 For Dummies®
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.
