Hi Radon,

To avoid pasting the formatting you could use:
..PasteSpecial Paste:=xlFormulas
or
..PasteSpecial Paste:=xlValues

Cheers


"Radon" wrote in message
...
In Excel Help, it says that the...Length of cell contents (text) is
limited
to 32,767 characters. Only 1,024 display in a cell; all 32,767 display in
the
formula bar.

I have a piece of VBA code that's been working fine until it ran into a
cell
with more than 1024 characters. See snipet below:

(1) varRowValues = oRow (varRowValues is a Variant and oRow is a Range)
(2) oSplitRows = varRowValues (oSplitRows is a Range as well)

The idea is to copy the values of oRow into oSplitRow. However, when oRow
has a cell w/ more than 1024 characters, line (2) crashes... If I use copy
and paste it seems to work but I end up copying formating as well. I'd
like
not to use copy/paste. Is there a way for this to work?

Thank you!