» 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:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft PowerPoint Version 2002 Step by Step
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Monte Carlo Methods in Finance
- Financial Peace: Revisited
No comments have been submitted.
