» 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:
- Marketing Plan: A Handbook with Marketing Plan
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Adventure Capitalist: The Ultimate Road Trip
- Business Plans For Dummies®
No comments have been submitted.
