Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
various printing from a hiden sheet
It might help if I added my code (I want this to print out on my printer):
Sheets("Stepdown3").Select Sheets("Letter").Visible = True Columns("B:B").Select For Each Cell In Selection.SpecialCells(xlConstants, 23) If Cell.Value < 0 Then Cell.Select With Sheets("Letter") .Range("C13").Value = Selection.Value .Range("E13").Value = Selection.Offset(0, -1).Value .Range("C14").Value = Selection.Offset(0, 1).Value .Range("I24").Value = Selection.Offset(0, 8).Value .Range("I27").Value = Selection.Offset(0, 7).Value .Range("I30").Value = Selection.Offset(0, 10).Value .PrintOut Copies:=1 End With With Sheets("Sheet2") .Visible = True .AutoFilter Field:=2, Criteria1:=Sheets("Letter").Range("C13").Value .PrintOut Copies:=1 End With End If Next Cell "Shawn" wrote: I have a hidden sheet with a table of data. Column B:B has various employee names in it in desending alphabetical order. I would like a macro that would, without selecting the page if possible, print out all rows of data with employee A, then, on another sheet, print out all rows of data with employee B, then employee C and so on. For example, if Smith, Tom is repeated in Rows B2, B3, B4, I would want it to print Rows 2, 3 and 4 on a sheet of paper. Then if Thompson, Jill is repeated in B5, B6, B7, I would want it to print rows 5, 6 and 7 on the next sheet. Please help. -- Thanks Shawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Hiden Pages | Excel Discussion (Misc queries) | |||
various printing from a hiden sheet | Excel Programming | |||
various printing from a hiden sheet | Excel Programming | |||
Is column hiden? | Excel Programming | |||
hiden sheet | Excel Programming |