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

--
Don Guillett
SalesAid Software
[email protected]
"Help with a Formula" <Help with a [email protected]> wrote
in message news:[email protected]...
>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?