set print area function not working
Atif
Aim: To use set print area to force 10 or more columns on to an A4
portrait piece of paper.
Problem: Set print area will only show you may be five columns in the
print preview area
In page break mode: If you insist on printing on one page, then each
cell is forced to become one page.
Do think this has anything to do with the default printer driver
installed, and that's why excel's set print area function won't work?
Incidentally I have a similar problem in MS Works spreadsheet in that
the set print area function will not work and you can only print may
be 5 columns instead of saying fitting ten columns on to one page.
Best Regards
Atif
David McRitchie
Sounds to me like you setting the print are to separate
columns rather than one contiguous area. But I just tried
that and even though I select column A, then Column B
by hold the ctrl key, etc, It showed up as one print area
$A:$H So could you tell us what you see when you
goto the VBE (Ctrl+11), in the Intermediate pane (Ctrl+G)
then type in (or copy and paste)
?ActiveSheet.PageSetup.PrintArea
The microsoft.public.excel* groups are hosted on Microsoft
newsservers. Most of us connect directly to the Microsoft
newsservers for quickest access and without having to look
at web pages. For most of us Google is not providing our
access, but is great for searching archived newsgroup
postings, and separately for searching web pages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Atif" <atif...@hotmail.com> wrote in message news:3f66ca4c.04090...@posting.google.com...