Hello,

My report page displays formula based data from the data sheet. I need to
increment up data data sheet (remove data from the lower row and then read
data in the current row). The catch is that I don't want to leave the report
sheet to move up to the next row in the data sheet.

So is there a way to determine what row the data sheet is on without having
to activate it? I noticed that selection.Address only works with
ActiveSheets.

Thanks,
Rich