Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Print Selection
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - Print Selection
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. 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Print Selection" doesn't print beyond automatic page breaks | Excel Discussion (Misc queries) | |||
CHANGE DEFAULT PRINT TO SELECTION INSTEAD OF ACTIVE WORKSHEET | New Users to Excel | |||
Print each drop-down list selection | Excel Discussion (Misc queries) | |||
How can I print frozen panes to appear above print selection in Ex | Excel Discussion (Misc queries) | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) |