close
I have a workbook with 35 tabs. I am looking for a formula that if the value
on worksheet 38,cell g57 is gt; 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(quot;sheet38quot;).range(quot;g57quot;)gt;7 then
sheets(quot;sheet35quot;).range(quot;a10:f30quot;).printout
end sub
--
Don Guillett
SalesAid Software
quot;Help with a Formulaquot; lt;Help with a gt; wrote
in message ...
gt;I have a workbook with 35 tabs. I am looking for a formula that if the
gt;value
gt; on worksheet 38,cell g57 is gt; then 7, print, worksheet name 35,cell range
gt; a10:f30.
gt;
gt; Is there such a formula?
全站熱搜
留言列表
