Sub RecordLocation() Set currentSelection = Selection TopRow = ActiveWindow.VisibleRange.Cells.Row TopCol = ActiveWindow.VisibleRange.Cells.ColumnEnd SubSub ReturnToLocation() currentSelection.Select ActiveWindow.ScrollRow = TopRow ActiveWindow.ScrollColumn = TopColEnd Sub