|  

» Change a Column or Columns to values using VBA in Microsoft Excel

VBA macro tip contributed by Ron de Bruin, Microsoft MVP - Excel
Sub Values_8()
    Columns("A").Value = Columns("A").Value
End Sub
Sub Values_9()
    Columns("A:C").Value = Columns("A:C").Value
End Sub



Rate This Tip
12 34 5
Rating: 3.00     Views: 19813
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments