在.NET Excel VSTO中，我可以识别活动窗口中当前可见的行吗？

I have a VSTO project that interfaces with a database to pull information into an Excel worksheet. I would like to determine if the last row pulled in from the database is currently visible in the window, and if not (and only if not) scroll the window to make it visible. Is there any way to determine if a row/cell/range is in the active window view or the range of rows/cells visible in the active window view?I have a VSTO project that interfaces with a da