Thread: Any way to copy contents of print area with macro?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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


Reply With QuoteReply With Quote