I am trying to code this correctly. Please Help
I am working with data sets taking up 10 rows, no merged cells and all cells the same height, each job list takes up 10 rows.
after selecting 10 rows making up 1 job, I want to cut them and insert them 10 rows up (moving the job above down to take its place)
I hope this makes sense.
I am using
Sub Move_Up()
Selection.Cut
Selection.Offset(-10, 0).Select
Selection.Insert Shift:=xlDown
End Sub
This works really well and there is no problem here.
The problem is when I try to move the job (contained in the 10 rows) down and move the job below up
I really hope this is making sense.
This is not working.
I am using
Sub Move_Dn()
Selection.Cut
Selection.Offset(10, 0).Select
Selection.Insert Shift:=xlDown
End Sub
This just appears to move the selection box down, but no data comes with it.
I need it to be a cut and insert as this data is in a Gantt chart.
I would really appreciate help with this
Thanks
JasonBing
I am working with data sets taking up 10 rows, no merged cells and all cells the same height, each job list takes up 10 rows.
after selecting 10 rows making up 1 job, I want to cut them and insert them 10 rows up (moving the job above down to take its place)
I hope this makes sense.
I am using
Sub Move_Up()
Selection.Cut
Selection.Offset(-10, 0).Select
Selection.Insert Shift:=xlDown
End Sub
This works really well and there is no problem here.
The problem is when I try to move the job (contained in the 10 rows) down and move the job below up
I really hope this is making sense.
This is not working.
I am using
Sub Move_Dn()
Selection.Cut
Selection.Offset(10, 0).Select
Selection.Insert Shift:=xlDown
End Sub
This just appears to move the selection box down, but no data comes with it.
I need it to be a cut and insert as this data is in a Gantt chart.
I would really appreciate help with this
Thanks
JasonBing