| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Selection is too large" error
I'm getting the above error (both in code and manually on the worksheet) when
attempting to copy a 1 x 5 (row x column) range to a 4000 x 5 range. The problem does not arise when pasting the same source range to another workbook, even when the target range is 65536 x 5 Any suggestions will be most welcome TIA -- David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Selection is too large" error
using XP and Excel 2003 copy paste works for me...
What is in the 5 cells?? "David" wrote: I'm getting the above error (both in code and manually on the worksheet) when attempting to copy a 1 x 5 (row x column) range to a 4000 x 5 range. The problem does not arise when pasting the same source range to another workbook, even when the target range is 65536 x 5 Any suggestions will be most welcome TIA -- David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Selection is too large" error
Hi,
I guess the cells might have some conditional formattings or the workbook has many formats close to the limit that the kb article show You receive a "Too many different cell formats" error message in Excel http://support.microsoft.com/default...b;en-us;213904 -- HTH, okaizawa Vacation's Over wrote: using XP and Excel 2003 copy paste works for me... What is in the 5 cells?? "David" wrote: I'm getting the above error (both in code and manually on the worksheet) when attempting to copy a 1 x 5 (row x column) range to a 4000 x 5 range. The problem does not arise when pasting the same source range to another workbook, even when the target range is 65536 x 5 Any suggestions will be most welcome TIA -- David |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Selection is too large" error
Thanks okaizawa,
I've cleared the formats and it works OK now -- David "okaizawa" wrote: Hi, I guess the cells might have some conditional formattings or the workbook has many formats close to the limit that the kb article show You receive a "Too many different cell formats" error message in Excel http://support.microsoft.com/default...b;en-us;213904 -- HTH, okaizawa Vacation's Over wrote: using XP and Excel 2003 copy paste works for me... What is in the 5 cells?? "David" wrote: I'm getting the above error (both in code and manually on the worksheet) when attempting to copy a 1 x 5 (row x column) range to a 4000 x 5 range. The problem does not arise when pasting the same source range to another workbook, even when the target range is 65536 x 5 Any suggestions will be most welcome TIA -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Selection is too large" problem | Excel Discussion (Misc queries) | |||
| "Center across selection" rather than "Merge cells" | Excel Discussion (Misc queries) | |||
| Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) | |||
| function "compile error msg: procedure too large" | Excel Programming | |||
| the "Procedure too large" error | Excel Programming | |||
Linear Mode
