» Change the selection with one or more areas 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_10()
Dim smallrng As Range
For Each smallrng In Selection.Areas
smallrng.Value = smallrng.Value
Next
End Sub
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Dictionary of Finance and Investment Terms
- Advanced modelling in finance using Excel and VBA
- Special Edition Using Microsoft Outlook 2002
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Access Version 2002 Step by Step
No comments have been submitted.
