Open excel sheet at last row - 5

[dori2o]

I'm using the following code to open worksheets in a spreadsheet used by a large number of people so that they don't have to trawl through row after row of data when opening the workbook.

Please Login or Register  to view this content.

With some of the sheets the lastrow -5 (the selected row) is in the middle of the screen. On some sheets it's the last visible row when then sheet is opened.

It seems to make no difference how many rows have been filled.

Is there a way to ensure that the selected row is shown as the top row in the window? (except where this is not possible as there are less that 5 rows of data.

For information, the top row (row 1) is a freeze pane with a row height of approx 45.

Thanks in advance.

[JLGWhiz]

Maybe this

Please Login or Register  to view this content.

[dori2o]

Thanks, worked a treat

[JLGWhiz]

Thanks, worked a treat

You're welcome,
regards, JLG