[Solved] VBA Macro that gets range of rows in column A and replace them with values in column B

by


Answer for your question

Sub Test()

Dim RangeX As Variant

RangeX = InputBox(" Enter Range of rows. For Example rows 3  & 4 Means 3-4")


Row1 = Left(Trim(RangeX), 1)
Row2 = Right(Trim(RangeX), 1)

For i = Row1 To Row2

Cells(i, 1).Value = Cells(i, 2).Value
Cells(i, 3).Value = "Values Replaced"
Next

MsgBox "Process Completed"

End Sub

1

solved VBA Macro that gets range of rows in column A and replace them with values in column B