if the value in cell g57>7,print worksheet named letter

[Help with a Formula]

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?

 

[Don Guillett]

Not a formula. try this macro

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