» Change a Row or Rows to values 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_6()
Rows("1").Value = Rows("1").Value
End Sub
Sub Values_7()
Rows("1:3").Value = Rows("1:3").Value
End Sub
Book Store:
Recommended Books:
- Investing for Dummies, Third Edition
- Seven Habits Of Highly Effective People
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Analyzing Markets, Products, and Marketing Plans
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Mastering Excel 2000 (for beginner)
No comments have been submitted.
