| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't paste as merge cells aren't identical
Running a macro that copies and paste special from one spreadsheet to another
and I get an error "operation requires merged cell's to be identically sized" but my cells aren't merged! Here's my code: Range("g3").Copy Workbooks(file).Activate Worksheets("D.3. PD - ASLD").Activate Range("e10").Select Selection.PasteSpecial Paste:=xlPasteValues The thing is that I have used almost identical code to copy the cells from the "copy from" spreadsheet into an identical sheet as the "copy into" sheet and it worked fine. Maybe I'm being foolish, but am sure that neither cell is merged. Any thoughts? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can't paste as merge cells aren't identical
Please ignore - error in the code further up.
"Muttley" wrote: Running a macro that copies and paste special from one spreadsheet to another and I get an error "operation requires merged cell's to be identically sized" but my cells aren't merged! Here's my code: Range("g3").Copy Workbooks(file).Activate Worksheets("D.3. PD - ASLD").Activate Range("e10").Select Selection.PasteSpecial Paste:=xlPasteValues The thing is that I have used almost identical code to copy the cells from the "copy from" spreadsheet into an identical sheet as the "copy into" sheet and it worked fine. Maybe I'm being foolish, but am sure that neither cell is merged. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep all cells in a column unique? No cells identical | Excel Worksheet Functions | |||
| Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions | |||
| merge/extract data from identical worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Inexplicable difference in row hiding speed - identical code, identical machines! | Excel Programming | |||
| Testing for Identical Cells | Excel Programming | |||
Linear Mode
