Macro for Print Loop within Excel

[Browner]

I have a series of graphs that are charted off of a full P&L statement
from a drop down window, which shows a graph representing each line of
the P&L as a percentage to Total Revenue.

What I need is a way to print these graphs with one macro as apposed to
changing the drop down to show which graph you want,and then manually
printing it. Also, there a many blank lines on the P&L and i want to
avoid printing all of that Junk, how can i avoid doing this?

 

[Don Guillett]

a loop


for each c in [mylist]
do your thing
next

 

[Browner]

Don,
I don't know what you mean, can you ellaborate?

 

[Don Guillett]

I assume that your drop down is a list somewhere. So a looping macro to
create the graph from the list as you are doing then print it. The macro
recorder may be your friend here giving you the idea of what is happening
when you create your graph and print it.

for each c in range("a2:a22")'[mylist]
create the graph
print the graph
next c ' do it for the next one in the list