Hi,

1. I have a pivot table that shows price data vertically for 30 stock
ticker symbols, by stock symbol and date.. There is a verying number of
rows for each respepctive stock symbol.

2. A Filter dropdown box on the Stock Symbol column allows selection of all
or some of the stock symbols.

3. At the bottom of the entire table, at row 1650 when Show All is chosen,
is a TextBox with a 30-line disclaimer.

4. My goal is to have this disclaimer displayed immediately under the last
data row of the stock ticker symbol(s) selected. This is a legal
requirement.

5. PROBLEM: If I choose say only one stock and the last data row is 200,
the Disclalimer textbox is still displayed at row 1650, with 1450 blank rows
between the last data row and the disclaimer. .

6. Hence, I need a way to capture an 'AfterUpdate' event for the dropdown
box and

A. Get the last row number of the data displayed, based onn the stock
symbol(s) chosen, and
B. Move the Disclaimer textbox to that last row number + 2. It might be
easier if I put the text in a named range of cells instead of a
text box, but either way, I need to re-position the Disclaimer.


Is there a way to do this each time a different selection is made from the
filter dropdown??

Thanks for any help you can give.

Alan