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
--
William<"M"
Using 2007


"tom" wrote:

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