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