Any way to copy contents of print area with macro?
 

I have a file that I need to copy the cells in the current print area so
I can paste them to another sheet. Is there a way to do this in vba?


--
uwajes
------------------------------------------------------------------------
uwajes's Profile: http://www.excelforum.com/member.php...o&userid=13424
View this thread: http://www.excelforum.com/showthread...hreadid=555009

Any way to copy contents of print area with macro?
 

In the worksheet, create a Defined Name that represents the print area.

Then in VBA, you can use that name for copy/paste.
--
Gary's Student


"uwajes" wrote:


I have a file that I need to copy the cells in the current print area so
I can paste them to another sheet. Is there a way to do this in vba?


--
uwajes
------------------------------------------------------------------------
uwajes's Profile: http://www.excelforum.com/member.php...o&userid=13424
View this thread: http://www.excelforum.com/showthread...hreadid=555009