Hey there ppl,
I've a problem copying one a value via macro, it runs fine most of the time but if a value like this appears, it always crashes. Can anyone help me with this, I couldn't find a work around yet.
'=> Description,...... Text Text.....
I assume the problem is because of the '= but I just need that in the other cell too.
With WSAeko.Cells(x, 2)
.Value = WSNew.Cells(j, 1).Text 'aeko
.Offset(0, 1).Value = WSNew.Cells(j, 2).Value 'maker
.Offset(0, 3).Value = WSNew.Cells(j, 5).Value 'descr
.Offset(0, 16).Value = WSNew.Cells(j, 6).Value 'descr2
.Offset(0, 5).Value = WSNew.Cells(j, 13).Value 'date
.Offset(0, 6).Value = WSNew.Cells(j, 14).Value 'date2
.Offset(0, 4).Value = WSNew.Cells(j, 16).Value 'info
.Offset(0, 2).Value = WSNew.Cells(j, 4).Value 'engines
End With
Bookmarks