Which printed page is it on?

[steve case]

I have a long list of items that prints on down many pages. I need a routine to tell me what page a particular item appears on.

This is so I can tell or E-mail someone, your item is on page so and so.

There's way too many for a simple ctrl-F find.

A good solution would be my item in column A and a formula in Column B that yielded the page number.

 

[stanleydgromjr]

StACase,

Is there a way to search for an item in Excel's Print Preview?

If you use Find to locate the item, highlight the row, then Format, Cells, Patterns, RED color - then do File, Print Preview, to manually locate the RED row, by pressing the 'Next' button, to find the page number.

Have a great day,
Stan

 

[Boller]

Define a name as follows :-

Name : pge

Refers to : =IF(ISNA(MATCH(ROW(),GET.DOCUMENT(64),1)),1,MATCH(ROW(),GET.DOCUMENT(64),1)+1)

Then just use : =pge


PS
Here's a macro to add the name :-

Sub Add_Name()
ActiveWorkbook.Names.Add Name:="pge", RefersToR1C1:="=IF(ISNA(MATCH(ROW(),GET.DOCUMENT(64),1)),1,MATCH(ROW(),GET.DOCUMENT(64),1)+1)"
End Sub

Note : the formula calculation might be quite slow, and if the pagebreaks change the formula will not automatically recalculate.

 

[steve case]

Thanks for the replies.

I asked this question for someone else, and I will have him try it out on Monday.

 

[steve case]

The user on who's behalf I asked the question sent me a short E-Mail this morning:

Steve,

It worked.

Thank you,