If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create a button to print certain tabs in excel 2003
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 |
#2
|
|||
|
|||
create a button to print certain tabs in excel 2003
Something like this perhaps. I assumed the cell to check is A1, and to
print B1:G50 if A125. 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|