» Change cells in the Activecell rowrange 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
This will change the cells in the columns A:D to values In the ActiveCell.Row
Sub Values_5()
With ActiveSheet.Range(Cells(ActiveCell.Row, "A"), Cells(ActiveCell.Row, "D"))
.Value = .Value
End With
End Sub
Book Store:
Recommended Books:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Yes, You Can Time the Market!
- Microsoft Word Version 2002 Inside Out
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
