Hi when I write the following small piece of VBA:

Sub Thresholds()

' Take the user to the Threshold update area

Range("O25").Select
End Sub

I want the cell selected (O25) to be in the TOP LEFT of the screen (it currently is in the middle so I can see Columns L onwards and rows 1 downwards

I only want to be able to see columns O onwards and 25 and downwards

Regards
Mandy

Hi Mandy

To set your cell selection to the TOP LEFT you can do the following:

Always start on Range ("A1") for consistency. Then select select the target cell

Then use the SmallScroll method as seen below in the updated Thresholds Sub.

NB You scroll to the right one less number than the taget column and scroll down one less numberthan the target row.

Sub Thresholds()

' Take the user to the Threshold update area

Range("A1").Select 'Always start at "A1"
Range("O25").Select 'The target cell
ActiveWindow.SmallScroll ToRight:=14 'One lees than the number of Columns
ActiveWindow.SmallScroll Down:=24 'One less than the number of Rows

End Sub