» 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:
- Absolute Beginner's Guide to Microsoft Excel 2002
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Excel 2002 Power Programming with VBA
- Windows XP All-in-One Desk Reference For Dummies
- The Guide to Understanding Financial Statements
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
