Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
With a lot of help from folks here, I've got the following working:
Sub PrintMine() Dim HPB As HPageBreak, FoundCell As Range Dim iCtr As Long, NumPage As Long, myNames As Variant myNames = Array( _ "Name1, Name1", "Name2, Name2", "Name3, Name3") For iCtr = LBound(myNames) To UBound(myNames) Set FoundCell = Range("A:A").Find(What:=myNames(iCtr)) NumPage = 1 For Each HPB In ActiveSheet.HPageBreaks If HPB.Location.Row FoundCell.Row Then Exit For NumPage = NumPage + 1 Next HPB Sheets(1).PrintOut From:=NumPage, To:=NumPage, preview:=True 'for testing Next iCtr End Sub Where Names are actually Lastname, Firstname of desired list from total names on the sheet. Every time that list changes, I have to edit the code and make sure I spell the new name(s) right and presumably make sure they're in alphabetical order (my assumption). Thought occured to me I could select them from a list, give that list a named range and use that, but I can't figure out how. Any efforts have resulted in Type Mismatch errors. i.e. myNames = Range("MyList").Value or ..Value2 or .Text Any help? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
copy named range to powerpoint | Excel Worksheet Functions | |||
Using a formula to create named range reference | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions |