How can I programatically identify the range of rows displayed by filtered
data? I programatically provide the filter value, and then need to copy the
results to another sheet.

Thanks.