+ Reply to Thread
Results 1 to 2 of 2

Determining the height and width of Print_Area in a closed workbook

  1. #1

    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. #2
    Registered User
    Join Date
    08-20-2003
    Location
    Luton, England
    Posts
    63
    Need to open the workbook.
    Suggest you get range called Print_Area and add up column widths and row heights.
    Regards
    BrianB
    Most problems are caused by starting from the wrong place.
    Use a cup of coffee to speed up all Windows processes.
    It's easy until you know how.
    -----------------------------------------

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1