» 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:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- How to Read A Financial Report
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- How to Pay Zero Taxes (Annual)
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
