Copying from 1 cell into merged cells & keep formatting

Rusty · Apr 9th, 2002, 06:50 AM

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 · Apr 9th, 2002, 08:06 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 06:50 AM	#1
Rusty Board Regular Join Date: Apr 2002 Location: Ithaca Posts: 107	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 ]

Apr 9th, 2002, 08:06 AM	#2
Rusty Board Regular Join Date: Apr 2002 Location: Ithaca Posts: 107	Please disregard the above post as I've figured out a workaround....