LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 29th 19, 09:23 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Jul 2019
Posts: 1
Default Can't paste into a merged cell

On Wednesday, June 5, 2002 at 12:22:01 AM UTC+3, John Dice wrote:
I have a macro that copies data from different worksheets
and pastes the data into a main sheet for printing.

In one part, the macro copies a long number from a single
(unmerged cell) on one sheet and tries to paste into a
merged cell (formerly 3 horizontal cells) on the Print
Sheet. I get an error message that says, "Cannot change
part of a merged cell."

This confuses me because I am able to copy data from the
SAME sheet and paste it into the nearby merged cell...I
just can't do it from a different sheet. Why?


When pasting ensure u have enough cells on the sheet. I just had the same problem but adding extra cells on the sheet worked. I was pasting values that exceeded the no of cells available and the next one was a merged cell so it could not work.. i added 10 more rows above the merged cell. Hope this works..

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to paste photo into merged cell llamalover54011 Excel Worksheet Functions 1 November 19th 08 03:48 PM
Merged cell paste NIGHTMARE [email protected] Excel Discussion (Misc queries) 2 May 9th 07 05:00 PM
Can I paste a paragraph of text into a merged cell? TCPohlman Excel Discussion (Misc queries) 3 February 16th 07 06:58 PM
How can I paste into a merged cell? Gary Reed Excel Discussion (Misc queries) 3 June 29th 06 02:41 PM
Copy Paste Merged Cell Format Jim May Excel Programming 6 November 11th 04 02:35 PM

All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017