» 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:
- Accounting Principles, with CD, 6th Edition
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Adventure Capitalist: The Ultimate Road Trip
- Microsoft Office XP Introductory Concepts and Techniques
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.
