» 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:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Mortgages For Dummies®
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
No comments have been submitted.
