» 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:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Analysis of Financial Statements
- Positioning: The Battle for Your Mind
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The Guide to Understanding Financial Statements
- The Interpretation of Financial Statements
No comments have been submitted.
