Scroll Macro

[kr80]

Sub auto_open()

Sheet1.Activate
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollRow = 5

End Sub

I can use the above macro to scroll to where needed however does anyone know if I could make the "5" variable. For example if lets say Cell A2 will determine which column and row will decide where to scroll?

[snb]

Please Login or Register  to view this content.