VBA - Print Selection

[Guest]

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

 

[Guest]

The VBA is a recorder of steps. Turn it on and record the processes you
would like to have repeted over and over ,then turn it off.
When you have finished your macro TEST IT. Then polish it up using VBE if
you have minor changes you need to make.
Next attach your sequence to a Icon.
Have fun.

WLM

 

[Dave Peterson]

Maybe you can drop the sort and use data|filter|autofilter (add a header row if
you don't have one).

Then filter on that column G to show just the values you want.

Print those visible rows

And data|filter|Show all
to see everything.