» 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:
- Marketing Plans That Work, Targeting Growth and Profitability
- Adventure Capitalist: The Ultimate Road Trip
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
