RE: [PCTECH] Excel ?

["Janet Jewell" <JanetJewell@xxxxxxxxxxxxxxxxx>]

'Hide' rows that you do not want to print by highlighting unwanted row
numbers, right clicking your mouse, and selecting 'Hide'.    

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of Mark Allen
Sent: Wednesday, May 12, 2004 1:35 PM
To: 'PC Technical Discussion for iSeries Users'
Subject: RE: [PCTECH] Excel ?

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.