I have a workbook with 35 tabs. I am looking for a formula that if the value
on worksheet 38,cell g57 is then 7, print, worksheet name 35,cell range
a10:f30.

Is there such a formula?

Not a formula. try this macro

sub printwhat()
if sheet("sheet38").range("g57")7 then
sheets("sheet35").range("a10:f30").printout
end sub

--
Don Guillett
SalesAid Software

"Help with a Formula" <Help with a wrote
in message ...
I have a workbook with 35 tabs. I am looking for a formula that if the
value
on worksheet 38,cell g57 is then 7, print, worksheet name 35,cell range
a10:f30.

Is there such a formula?