On Sep 14, 5:36*am, Joel <(E-Mail Removed)> wrote:
> the problem is the screen is inj pixels and the page size is in inches. *The
> mapping between the pixels and the inches is dependant on the print driveand
> the size of you monitor. *One way to minimize the vairbles is to set the
> printer option to scale to fit paper size. *Then in excel set the Printarea.
> *the you have to figure the number of pixels arre in the print areaa you
> defined on the worksheet. *
>
> The run this macro to find the number of pixels in your print area
>
> Sub Macro1()
> '
> ' Macro1 Macro
> ' Macro recorded 9/14/2009 by jwarburg
> '
>
> '
> StartRow = InputBox("Enter Start Row")
> EndRow = InputBox("Enter End Row")
> StartCol = InputBox("Enter Start Column")
> EndCol = InputBox("Enter End Column")
>
> PixelsRow = 0
> For RowCount = StartRow To EndRow
> * *PixelsRow = PixelsRow + Rows(RowCount).RowHeight
> Next RowCount
>
> PixelsCol = 0
> For ColCount = StartCol To EndCol
> * *PixelsCol = PixelsCol + Columns(ColCount).RowHeight
> Next ColCount
>
> MsgBox ("Your area is " & PixelsRow & " high by " & PixelsCol & " wide")
> End Sub
>
> The print scaling will scale proportionaly so the so you have to figure out
> wha the scaling ratios are. *And then in the end you will havve to makeminor
> adjustments for the border area the print dirve is using or change the size
> of the border.
>
>
>
> "tchrapkiewicz" wrote:
> > Thanks, But I'm looking for a more well-defined approach.
>
> > anybody?
>
> > Thanks,
> >TomC
>
> > On Aug 23, 5:48 pm, Joel <J...@discussions.microsoft.com> wrote:
> > > The best way is to experiment manually. *The print menu has a scaleoption
> > > and adjust the scale numbe to meet your requirements. *the workshetis
> > > dimensioned in pixels and the only inch (cm) options ar on the print menu for
> > > the border.
>
> > > "tomcee" wrote:
> > > > I am generating charts with excel and would like it, when printed to
> > > > be at a specific scale.
>
> > > > For instance, I have a xy chart which has a circle plotted on a grid
> > > > that I would like to print as 10 squares per inch (or possible 2
> > > > squares per centemeter) grid on the paper, and the circle to be
> > > > precisely 3 inch diameter.
>
> > > > Any assistance or direction would be appreciated.
>
> > > > Thanks in advance,
> > > >TomC- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
Joel:
Thank you very much! This seems to be what I was looking for. I'll
give it a try.
Regards,
TomC
|
Similar Threads
