To avoid overwriting, you need to exclude the end-of-cell markers from what is copied (clicking on the ¶ symbol on the Ribbon's Home tab will reveal them, if they're not already visible). That means you can only transfer the date one cell at a time.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|