asked on

VBA Excel - the picture is too large and will be truncated

Hi,

I have some code in Access that copies a range of rows (normally about 1000) into another sheet. All these rows contain is text & numbers. Having run the code a few times it worked fine but not it pops up with the following error message "the picture is too large and will be truncated".

Can anyone tell me what this is about? The only thing I can think of is my clipboard is full but otherwise have no idea.

Any help would be great once again,

Mark

RichardSchollar

Hi Mark

I think it would be beneficial if we could see this code that is doing the copying.

Richard

mcs26

ASKER

Hi Richard

Please see the code below, I have to copy different sheets and ranges four times but they all have the same format as below. I have just inserted .CutCopyMode = False after copying and it seems to be running ok again now. However I would still like to know the actual cause.

.Sheets("AHYFND").Range("A5:I" & NRow).Copy
.Sheets("Single_ISIN").Range("A" & LRow + 1).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, False

Thanks

RichardSchollar

Well, there's nothing wrong with your code. You say you are running this out of Access? Maybe this is an Access-specific problem with using the Excel object library? I'm afraid i doubt I can be of any further help so i will take a backseat and see what others post.

Richard

mcs26

ASKER

Ok, thanks anyway Richard

ASKER CERTIFIED SOLUTION

RichardSchollar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial