something like

for each ws in worksheets
if ws.range("g1")0 then activesheet.printout
next ws

--
Don Guillett
SalesAid Software

"JoeP" wrote in message
...
I would like to know the code for use in a macro that will
1. look at cell G1 in a sheet and if there is a number in that cell print
the sheet
2. move to the next sheet and look at cell G1 and if there is a number in
that cell print the sheet
3. continue to move to each sheet in the file test cell G1 to see if there
is a number and print the sheet if there is.

Thanks for any help.