View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt G[_2_] Matt G[_2_] is offline
external usenet poster
 
Posts: 14
Default Printing macro, selected rows only

Hi,

I have a macro to import a file and sort by column A and set a page break
each time the value on column A changes. Next I only want to print certain
rows on each page and I can't figure out how to do it.

For example, I only want to print row 2 if the value of cells P2 through U2
are all zero(invidually, not a sum) and the value of cell V2 is zero.

Any thoughts?