The picture is too large and will be truncated

[Dhruba Bandopadhyay]

The picture is too large and will be truncated

This is what I get in Excel 97. I searched on the internet and only could
find a MS KB article referring to Office 2000. It also appears that this is
some kind of bug... that has been in the Office suite since 97 and still is
in Office 2003, etc.

I have VBA code copying and pasting text rows. There are no image picture
involved. But when I get this message, I do not get any reference of where
it was in VBA code.

How can one find out more about this bug?

 

[NickHK]

I have got this error when Copy/Paste as Picture, never when working with
ranges/rows etc.

NickHK

 

[Dhruba Bandopadhyay]

Does anyone know how to contact Microsoft Office development team, the ones
who made Excel 97?

Am not requesting a bug fix to their 1997 program, but at least tell us why
or what makes this error message come up.

 

[Dhruba Bandopadhyay]

By copy and paste text rows do you mean entire rows of a
spreadsheet with text in the cells? Please post the code you are using for
this operation.

This is the only piece of code that does copy/paste:

Set MoldRow = oSheet.Rows(CurRow + TableRow - 2)
MoldRow.Copy
oSheet.Rows(CurRow + TableRow - 1).PasteSpecial Paste:=xlPasteFormats,
Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

So as you can see it's copying a whole entire row from 2 rows above, to 1
row above.


Any ideas on how to suppress the error bug message?