copy cells with more then 255 chars...
This worked as well to match your parameters exactly:
Sub TestCopy()
Debug.Print Len(ActiveCell)
ActiveCell.Copy
ActiveSheet.Next.Range("B9").PasteSpecial Paste:=xlAll, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Debug.Print Len(ActiveSheet.Next.Range("B9"))
End Sub
Produced
678
678
--
Regards,
Tom Ogilvy
|