Hello,
I require some help on modifying below code to be able to copy range from one workbook into another workbook only into blank cells:
So this is working if I need to paste range in the same worksheet - into column C, but I require to paste it into different workbook and for Range("A:O").
Any help much appreciated.
I require some help on modifying below code to be able to copy range from one workbook into another workbook only into blank cells:
Code:
Sub CopyRangeToRange()
Dim CpyFrom As Range
Dim Cell As Range
Set CpyFrom = ActiveSheet.Range("A:A")
For Each Cell In CpyFrom
If Cell.Value <> vbNullString Then
Cell.Offset(0, 2).Value = Cell.Value
End If
Next Cell
End Sub
So this is working if I need to paste range in the same worksheet - into column C, but I require to paste it into different workbook and for Range("A:O").
Any help much appreciated.