a loop


for each c in [mylist]
do your thing
next

--
Don Guillett
SalesAid Software

"Browner" wrote in
message ...

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?


--
Browner
------------------------------------------------------------------------
Browner's Profile:
http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=543105