"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

"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

"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

"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