Tip Printed from ExcelTip.com
Change a Row or Rows to values to values using VBA in Microsoft Excel

VBA macro tip contributed by Ron de Bruin, Microsoft MVP - Excel 



Sub Values_6()
    Rows("1").Value = Rows("1").Value
End Sub
Sub Values_7()
    Rows("1:3").Value = Rows("1:3").Value
End Sub