» Change a Column or Columns 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_8()
Columns("A").Value = Columns("A").Value
End Sub
Sub Values_9()
Columns("A:C").Value = Columns("A:C").Value
End Sub
Book Store:
Recommended Books:
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Marketing Plans That Work, Targeting Growth and Profitability
- Windows XP Pocket Reference
- Microsoft Access Version 2002 Step by Step
No comments have been submitted.
