» 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
CATEGORY - Cells, Ranges, Rows, and Columns in VBA
VERSION - All Microsoft Excel Versions
Sub Values_6()
Rows("1").Value = Rows("1").Value
End Sub
Sub Values_7()
Rows("1:3").Value = Rows("1:3").Value
End Sub
Book Store:
Recommended Books:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Harry Potter and the Order of the Phoenix (Book 5)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
