Copy cell with more than 921 charcters

Hello,

I wrote a vb code to copy all rows where column B contains "RW". The code first deletes any data that the sheet might already have. Following is the code:

Sub Renewals_Click()
Set e = Sheets("Renewals")
Set k = Sheets("To be Engaged")

Dim d
Dim m
d = 4
m = 2

Do Until IsEmpty(e.Range("B" & d))

e.Rows(d).Value = ""
d = d + 1
Loop

d = 3
Do Until IsEmpty(k.Range("B" & m))

If k.Range("B" & m) = "RW" Then
d = d + 1
e.Rows(d).Value = k.Rows(m).Value
End If
m = m + 1
Loop
End Sub

I hit error 1004 when this code tries to copy a cell that contains more than 921 characters. Does anyone has a solution to overcome this error?!?!


Thanks in advance!