Good day all,

So I picked up a book at Barnes n' Nobles last week and started formally learning Code for VB. Not as Hard as I thought. I was wondering of someone out there could help me with the following exercise.....

I want to make the current active cell the upperleft most cell in the current view. So for example.....the Active cell is R33 and I hit the "button", I want it to make R33 the upperleft most cell on the screen. Kind of like where A1 is the upperleftmost cell when you open Excel at first.

I need this little bit of code to finish my first gheto Hallo world "finder" Macro.

Anyone have any ideas, dont have to be to pretty.

Wazar,

Try the following:-

Private Sub CommandButton1_Click()
Dim rw As Long
Dim cl As Long
rw = ActiveCell.Row
cl = ActiveCell.Column
Range("A1").Select
ActiveWindow.SmallScroll Down:=rw - 1
ActiveWindow.SmallScroll ToRight:=cl - 1
Cells(rw, cl).Select
End Sub

Cool.....

That was simple. I see now how to tie it all together. Thanks friend, this really helps me in my development!