» 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:
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Windows XP All-in-One Desk Reference For Dummies
- Keys to Reading an Annual Report (Barron's Business Keys)
- Mastering Excel 2000 (for beginner)
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
