» 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:
- Excel 2002 Power Programming with VBA
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Now, Discover Your Strengths
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The 22 Immutable Laws of Branding
- Microsoft Access 2002 for Dummies
No comments have been submitted.
