I gave you a response, with a macro, in your previous thread dated 23 Dec.
Otto

"Allan Grates" wrote in message
...
I'm looking for a solution for an item search box for an inventory. I have
a
spreadsheet that I need to find "Name of product" and scroll it up to the
bottom of my frozen pane. I've searched the discussions forum and tried
several formulas, non have worked for me.
In my frozen panes view, I'm looking to have a search box to type an item
name in and have excel scroll it up to the bottom of the frozen pane. The
item names are in column "D".
Any takers?????
Thanks, Allan Grates