Copying from 1 cell into merged cells & keep formatting

[Rusty]

Hi,

I've built a macro that selects information from "sheet2" based on a vlookup formula as entered on "sheet1".

The macro then picks up the relevent field from "sheet2" and pastes it in "sheet1"

The problem is:

The target position on "sheet1" is merged cells (14Rx12C) but the source information comes from "sheet2" is in 1 cell (1Rx1C)

Is there any way that I can transfer the information across, so that it has multiple lines in it?

For example, if you edit a cell, then press "alt+enter" you can write on the "next line" within the cell. But if I do this, it transfers across with a little square in place of the gap.

Any thoughts?

Thanks,
Rusty
This message was edited by Rusty on 2002-04-09 05:51

 

[Rusty]

Please disregard the above post as I've figured out a workaround....