| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining the height and width of Print_Area in a closed workbook
Need to open the workbook. Suggest you get range called Print_Area and add up column widths an row heights -- Brian ----------------------------------------------------------------------- BrianB's Profile: http://www.excelforum.com/member.php...tinfo&userid=5 View this thread: http://www.excelforum.com/showthread.php?threadid=38651 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| columb width/height | New Users to Excel | |||
| Column Width and Row Height | Excel Worksheet Functions | |||
| Height/Width measurements | Excel Worksheet Functions | |||
| Determining last row/column using ADO with closed workbook | Excel Programming | |||
| Setting width and height | Excel Programming | |||
Linear Mode
