» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Accounting Principles, with CD, 6th Edition
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Accounting for Dummies
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
