|
midrange.com
You should be able to hide the rows/columns that you don't want, set your
print area, and only get what you see.
Dave Parnin
Nishikawa Standard Company
Topeka, IN 46571
daparnin@xxxxxxxxxxxxxxxxxx
Mark Allen
<mallen@xxxxxxxx> To: PC Technical
Discussion for iSeries Users
<pctech@xxxxxxxxxxxx>@SMTP@CTB
05/12/2004 03:34 cc:
PM Subject: RE: [PCTECH] Excel ?
Please respond to
PC Technical
Discussion for
iSeries Users
<pctech@midrange.
com>
Problem is they are intermixed, may have 4 rows in a row not red, the 2 red
then 3 not then 4 red
Mark Allen
IS Manager
Wilkes Telephone & Electric
11 W. Court Street
Washington, GA 30673
Phone: (706) 678-9565
Cell: (706) 498-7907
Fax: (706) 678-1000
-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of rware@xxxxxxxxxxxxxxxx
Sent: Wednesday, May 12, 2004 4:27 PM
To: pctech@xxxxxxxxxxxx
Subject: RE: [PCTECH] Excel ?
If you have rows that aren't together I don't think the selecting the range
thing is going to work. I am sure it would be possible though with a macro
with some vba.
> -----Original Message-----
> From: Mark Allen [SMTP:mallen@xxxxxxxx]
> Sent: Wednesday, May 12, 2004 3:10 PM
> To: pctech@xxxxxxxxxxxx
> Subject: [PCTECH] Excel ?
>
> I have a spreadsheet that has certain ones where one of more of 3
> columns is in red. Is there any way to just print those rows
>
> Mark Allen
> IS Manager
> Wilkes Telephone & Electric
> 11 W. Court Street
> Washington, GA 30673
> Phone: (706) 678-9565
> Cell: (706) 498-7907
> Fax: (706) 678-1000
>
> _______________________________________________
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing
> list To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.
_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.
_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
