Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print button macro & specific tabs to print | Excel Worksheet Functions | |||
How do I create a button to print several worksheets in Excel? | Excel Worksheet Functions | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
How do I create a print button? | Excel Worksheet Functions | |||
How do I setup a print command button in excel 2003 | New Users to Excel |