Hi Team,
I would like to have a macro which copies the entire row number 2 to row number 1 within same sheet. Say sheet name is "Karthik".
Thanks,
Karthik
Hi Team,
I would like to have a macro which copies the entire row number 2 to row number 1 within same sheet. Say sheet name is "Karthik".
Thanks,
Karthik
Here is a simple line of code to do that:
Sub copy_row()
Range("A2").EntireRow.Copy Range("A1")
End Sub
It works on whatever sheet you are looking at when you run the macro, whichever sheet is active.