Moving the contents one cell up in a column

Solved/Closed
Report
-
 Sumit -
Hello,
In my excel sheet the column C has contents in alternate cells starting from C1 till end. It looks like
C
1 heading
2
3 d1
4
5 d2
6
. .
. .

Now i want to move the content one cell up in the column except the heading. It should look like
C
1 heading
2 d1
3
4 d2
5
6 d3
. .
. .

Can u give the code for this modification.

Thank you

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You could have easily seen it by recording macro and recording action.

Range("C2").Select
Selection.Delete Shift:=xlUp
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

thanks a lot..... it was really easy.