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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top