vba courses london - Select cell - change view

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