View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default VBA - Print Selection

In an excel workbook I have columns A - J, I want a macro that will select a
print range based on..... column "G". Column G will either be populated with
(blank) or "Bring In". Once sorted the rows with Bring In will be on the top
of the sheet, which is the rows that I want printed.

Example... If the first 38 rows have "Bring In" in column "G" I want the
print range A1:J38 to print.

Any ideas?

TFTH,
Tom