Prev: Multiply Cell Values which include text units
Next: left/right or center ?
From: larry504 on 11 Mar 2010 11:20
I would like a way to search every tab in 1 workbook and the same cell on
each tab, than based an the value in the cell print the page or not
From: Otto Moehrbach on 11 Mar 2010 16:34
Something like this perhaps. I assumed the cell to check is A1, and to
print B1:G50 if A1>25. Post back if you need more. HTH Otto
Sub PrintIf()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
With ws
If .Range("A1") > 25 Then
.Range("B1:G50").PrintOut
End If
End With
Next ws
End Sub

"larry504" <larry504(a)discussions.microsoft.com> wrote in message
news:37A168ED-D492-4527-923E-1BBD40E50BAD(a)microsoft.com...
> I would like a way to search every tab in 1 workbook and the same cell on
> each tab, than based an the value in the cell print the page or not

 | 
Pages: 1
Prev: Multiply Cell Values which include text units
Next: left/right or center ?