» 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:
- Microsoft Excel VBA Programming for the Absolute Beginner
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Fall of Advertising and the Rise of PR
- Now, Discover Your Strengths
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Fish! A Remarkable Way to Boost Morale and Improve Results
No comments have been submitted.
