Pasting Format and values

L

LB79

Hello - I have a macro that creates a report (with formatting and logo),
copies the report page to a new workbook, and saves it. It works well
except that i can only copy either the formatting (inc logo/grid lines
etc) and have my data show as #value, or the data (numbers and text
only). Is there a way i can easily copy the whole report so that the
formatting AND values show?

Thanks
 
E

Excel_Geek

Can you try first pasting values then pasting formats?

e.g.

Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Selection.PasteSpecial Paste:=xlPasteFormat
 
E

Excel_Geek

Can you try first pasting values then pasting formats?

e.g.

Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Selection.PasteSpecial Paste:=xlPasteFormat
 
E

Excel_Geek

Can you try first pasting values then pasting formats?

e.g.

Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Selection.PasteSpecial Paste:=xlPasteFormats
 
L

LB79

Ive tried this but it doesnt paste everything... logos (jpg) are missin
etc.

Anything else i can do?

Thank
 
E

Excel_Geek

Are there more than one images you want to copy and paste? Try
something like this:

ActiveSheet.Shapes("Picture 1").Select
Selection.Copy
Sheets("(whatever the sheet is named)").Select
Range("(whatever cell it goes in...)").Select
ActiveSheet.Paste

"Picture 1" is by default what Excel/VBA will name the image. You can
find out if your logo is named something else by simply recording a
macro where you copy and paste the logo.
 
Top