» 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:
- Mortgages For Dummies®
- Writing Excel Macros with VBA, 2nd Edition
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Business Plans Kit for Dummies (With CD-ROM)
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
