We write the VBA coding to allow the Excel to do the repetitive work automatically within less time. In this chapter you will learn about how to change a row(s) to value(s) using VBA in Microsoft Excel.
Let’s take an example and understand how to write the VBA code for change a row(s) to value(s) using VBA.
How to change rows value to rows value?
We have data in Excel, in which we want the change the 1st rows value to 2nd rows value.
Follow below given steps:-
Sub Values_6() Rows("1").Value = Rows("2").Value End Sub
How the change the multiple row values from other multiple row values?
We have 2 groups of row values, we want to change the 1st group value with the 2nd group value.
To change the value follow below given steps and code:-
Sub Values_7() Rows("1:3").Value = Rows("5:7").Value End Sub
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.