» 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 Windows XP Step by Step (With CD-ROM)
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Retire Young, Retire Rich
- Learn MS Excel 2002 VBA/XML Programming
- Investing in Real Estate, Fourth Edition
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
