Excel 2010 "this image cannot currently be displayed" 'Running' macro 1

[PWD]

The following part of this code gives me the above error:-

            Range("a" & 1 + HeaderRow, Cells(SourceEndRow, SourceEndCol)).Copy
        
            End With
    
    SourceWb.Close savechanges:=False
    
    Windows(OriginalWorkBook).Activate
    Sheets(1).Range("A" & OEndRow + HeaderRow).PasteSpecial Paste:=xlPasteAll

If I step through the code (F8) it seems to work just fine but if I either 'F5' or run it (completely) from a button, the destination sheet just has a rectangle with a red 'x' in the upper left corner with the message

 this image cannot currently be displayed

in it.

If I add a 'Toggle Breakpoint' at the

 copy

line and then 'F8' to the next line, I can F5/Run from there just fine. If I move the 'Toggle' to the

 paste

line & F8 from there the error still occurs.

Both of these files are on a network drive - but I can't see the significance of that!

Any ideas?

Many thanks,
Des.

 

[SkipVought]

Try this...

            Range("a" & 1 + HeaderRow, Cells(SourceEndRow, SourceEndCol)).Copy
            thisworkbook.Sheets(1).Range("A" & OEndRow + HeaderRow).PasteSpecial Paste:=xlPasteAll

            End With
    
    SourceWb.Close savechanges:=False

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PWD]

All Riiighttt!!!!!

Many thanks Skip.

Des.