Paste issue in active cell with Macro using relative reference

Hi Andy,
My name is Pat Hardinge and thankyou for your reply but I am unsure how this helps. How does ="=R[-3]C[-5]+R[-3]C[-4]" mean "PASTE" from the clipboard into a single cell?

Hi,
Unfortunately the only tool I can use is excel for migration of a lot of data from an old database. One of the many dozens of columns used in this migration has one column which can have 2000 characters with line breaks which needs to be pasted into the cell using F2. That is why the formula. I can do it manually, but as there are many thousand rows to be done, I was hoping to create a macro for this migration. But it looks like it cannot be done.

Anyway thanks for both of you trying to assist

I am sorry for not making it very clear. I am copying text from a Word document onto the clipboard. This text which maybe 2000 characters long and has line breaks, paragraphs etc, which is then pasted into a single excel cell but at column BR. That is why this cell need to be in edit mode which brings up the formula bar.

Then I go to the next line and copy another selection of text from the word document.

Hi Holger,
I know this is confusing but there is no cell to copy. The text that is pasted into the single cell is text from a word document. Please understand that the copied text is from a word document. An example that could be used is as follows, copy and then paste into a single excel cell.

This text is make believe!
1. Open the external door.
2. Let the big brown spider in.
3. The spider eats the fly.
4. Now squash the spider.

If you paste this without edit cell, it populates a new line in a new cell. If you create a macro to do this task, the macro creates only one cell but keeps the original text where as I want to copy a new text. Please view this macro below but understand that the text must change at each row.

Please Login or Register  to view this content.

A good try Andy, but no the escape key deletes the data in the cell and the macro

Hi Norie,
At the moment, I just want to confirm that I cannot use a macro to paste "text" into an edited cell in excel. It is strange that it can be manually but not with a macro. If there are no smart options for me to use then I will re-consider the way to migrate the old database including SSRS and export to excel.

Regards, Pat