hi

how can i find on what page a cell is located?

i have sorted a list based on one of my column - cities and insered
page break when records for another city starts. so if i can get wha
page(s) the list for that city is located, i can a make an input box t
get the city's name from the user

thank

--
Message posted from http://www.ExcelForum.com