I fear the answer to this question very simple and i've overlooked something obvious.
I have a
simple macros which copies a worksheet and "exports" it to a new workbook. It works on the whole, but in the original
document there is a picture/logo at the top, which doesn't get copied to the new workbook.
Any ideas how to get
it to do this?
Here's the code i am currently using
Application.ScreenUpdating = False
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
ActiveWindow.Zoom = 75
Application.CutCopyMode = False
Application.DisplayAlerts = False
Application.DisplayAlerts = True
Application.ScreenUpdating = True
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Any help ould be appreciated :-)