» 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
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 Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Excel VBA Programming for the Absolute Beginner
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Microsoft Excel Version 2002 Step by Step
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
No comments have been submitted.
