Excel 2003 - VBA - A simple copy and paste

C

C Brandt

I know (I think) that I accomplished this at one time but I cannot seem to
get it working again.

I need to copy a section of a worksheet and paste it into another worksheet.
The problem is that the sheet I am coping from has merged cells and when I
try to paste, it gives me the ugly message that it cannot do this with the
formatting .

I tried pasting values. NG
I tried pasting formats first then values. NG

Is there something I'm missing?

Thanks for any help, Craig
 
G

Gord Dibben

Welcome to the Wonderful World of Merged Cells which causes so many problems it
should have been removed from Excel with the SR-1 patch after being introduced
in XL97 and never added to later versions.

Unmerge the cells and do your copying/pasting.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Past Values AND Formatting AND Text 1
Copy and Paste 10
I can't copy and paste equations 0
Preserve borders during copy and paste? 1
Excel Copy & Paste Issue ?? 5
Copy and pasting values of filtered rows 1
Copy/Paste into merged cells 2
Multiple worksheet Copy Paste Macro 2

Top