copying cells

D

Dave Unger

Hello,

I accidentally discovered this recently, can't seem to discover why.

This code truncates anything past 1024 characters:

Cells(2, 1) = Cells(1, 1).Text

while this will copy everything

Cells(1, 1).Copy Cells(2, 1)

I thought they were pretty much equivalent, obviously they're not.
Does this indicate, as it seems to, that the 2nd example is the
preferred way to go?

I just got my John Walkenbach book (Excel 2000 Power Programming with
VBA) in the mail today, but even a quick perusal through this worthy
tome did not reveal the answer.

Thanks for any insight to this,

Dave Unger
 
Top