Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting Format and values
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 -- LB79 ------------------------------------------------------------------------ LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156 View this thread: http://www.excelforum.com/showthread...hreadid=397202 |
#2
|
|||
|
|||
Can you try first pasting values then pasting formats? e.g. Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Selection.PasteSpecial Paste:=xlPasteFormats -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=397202 |
#3
|
|||
|
|||
Can you try first pasting values then pasting formats? e.g. Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Selection.PasteSpecial Paste:=xlPasteFormats -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=397202 |
#4
|
|||
|
|||
Can you try first pasting values then pasting formats? e.g. Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Selection.PasteSpecial Paste:=xlPasteFormats -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=397202 |
#5
|
|||
|
|||
Ive tried this but it doesnt paste everything... logos (jpg) are missing etc. Anything else i can do? Thanks -- LB79 ------------------------------------------------------------------------ LB79's Profile: http://www.excelforum.com/member.php...o&userid=12156 View this thread: http://www.excelforum.com/showthread...hreadid=397202 |
#6
|
|||
|
|||
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. -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=397202 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert date values to non-date format e.g. 01-06-78? | Excel Discussion (Misc queries) | |||
Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
MS Excel should allow you to format numerical values to thousand. | Excel Worksheet Functions | |||
format negative values in parenthesis | Excel Worksheet Functions | |||
time format and adding tiome values. | Excel Worksheet Functions |