» 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:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Wall Street Journal Guide to Understanding Money and Investing
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Financial Statement Analysis with S&P insert card
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
No comments have been submitted.
