I have a worksheet which has names in the first column (starting at A2). My macro sorts on that column. I now need to paginate the worksheet such that there is a page of names for each letter of the alphabet.
What I am doing now is manually creating the pagebreak with: Worksheets("Sheet1").Rows(20).PageBreak = xlPageBreakManual. Since the row number will change in the future (it is being pulled from an SQL Server), I need to be able to find the row number (in this case 20) each time the name changes its first letter. How to do this?
Bookmarks