View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dave.cuthill@computalog.com is offline
external usenet poster
 
Posts: 53
Default Determining the height and width of Print_Area in a closed workbook

Is there a way to determine the height and width of the Print_Area
range in a closed workbook using VBA.

Ultimately I want to determine the dimensions of the Print_Area so that
when I import it into a word document I maintain the aspect ratio of
the object.