» 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:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- PowerPoint® 2002 For Dummies®
- Marketing Plans That Work, Targeting Growth and Profitability
- Investments + S&P Card + Powerweb + StockTrak discount coupon
No comments have been submitted.
