» Change only the CurrentRegion of the ActiveCell 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_2()
With ActiveCell.CurrentRegion
.Value = .Value
End With
End Sub
Book Store:
Recommended Books:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Microsoft Office XP Introductory Concepts and Techniques
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Special Edition Using Microsoft Outlook 2002
- Financial Peace: Revisited
- Microsoft Office XP Step-By-Step (With CD-ROM)
No comments have been submitted.
