Hi!

Doesn't help with wanting a macro but here's a formula that will do what you
want:

Assume last names are in the range B2:B200

In a cell, say, J1 enter the letter of the last name that you want to find.

Either one of these formulas entered as an array using the key combo of
CTRL,SHIFt,ENTER:

=MIN(IF(LEFT(B2:B200)=J1,ROW(2:200)))

=MATCH(J1,LEFT(B2:B200),0)+1

Biff

"Bking" wrote in message
...
I have a large worksheet contains rwos with name and address columns. it
is
sorted in ascending order by the last name column and address. I want to
print a list of the names and addresses with page breaks at specific
letters.
How can I locate the first row with a last name beginning with a specific
letter so that I can insert a page break? I know I can do this manually
by
scrolling throught the list, finding the right row, selecting it and
inserting a page break. However, I would like to create a macro to insert
all the page breaks automatically.