View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Find Certain Cell Value and Print that Page Number

I have a Worksheet that is sorted by our Sales Peoples initials in Col. B. I
have code that Loops down Col. B and inserts a horizontal page break when
there is a change in sales persons initials. For example;

AA Page 1
AA
Horizontal Page Break
BB Page 2
BB
Horizontal Page Break
CC Page 3
CC

Is there a way to select all rows with initials "AA" and then Print Selection?