» Change range with more then Area 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_4()
Dim smallrng As Range
For Each smallrng In Range("a1:c10,e12:g17").Areas
smallrng.Value = smallrng.Value
Next
End Sub
Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- The 11 Immutable Laws of Internet Branding
- Advanced modelling in finance using Excel and VBA
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
No comments have been submitted.
