anne.gomes
05-26-2014, 03:32 PM
Hi,
So I want to fill down content from previous cell in column B and paste it to the length of data in column C. And then I want to delete all the previous content in column B right up until what I just pasted.
I have this code so far which copys and fills down right to the bottom. I now need to add length to it and also to delete all the previous content in the same column that I just copied and filled down from.
Sub FillCellsFromAbove()
Application.ScreenUpdating = False
On Error Resume Next
With Columns(2)
.SpecialCells(xlCellTypeBlanks).Formula = "=R[-1]C"
.Value = .Value
End With
Err.Clear
Application.ScreenUpdating = True
End Sub
Please help i am fully lost on how to do this....
Thanks so much in advance! Sorry if I was confusing.
So I want to fill down content from previous cell in column B and paste it to the length of data in column C. And then I want to delete all the previous content in column B right up until what I just pasted.
I have this code so far which copys and fills down right to the bottom. I now need to add length to it and also to delete all the previous content in the same column that I just copied and filled down from.
Sub FillCellsFromAbove()
Application.ScreenUpdating = False
On Error Resume Next
With Columns(2)
.SpecialCells(xlCellTypeBlanks).Formula = "=R[-1]C"
.Value = .Value
End With
Err.Clear
Application.ScreenUpdating = True
End Sub
Please help i am fully lost on how to do this....
Thanks so much in advance! Sorry if I was confusing.