I have searched this site but I didn't find the answer to this question.
I have created Command Button to bring me down to rows then other buttons to bring me back to the top of the page. I have a file with over 1200 rows.
My problem is that I need to add rows in between the buttons but every things change. I need a way to set a cell for the button and it would be floating. It wouldn't matter how many rows I insert in between then.
Here is an example of what I have done.
Private Sub CommandButton1_Click()
Range("A900").Select
End Sub
Private Sub CommandButton2_Click()
Range("A3").Select
End Sub
I have many schools, a buttom bring me at the beginning of the school rows then at the end a buttom bring me back up.
Thanks for your help, I'm a beginner.
I have created Command Button to bring me down to rows then other buttons to bring me back to the top of the page. I have a file with over 1200 rows.
My problem is that I need to add rows in between the buttons but every things change. I need a way to set a cell for the button and it would be floating. It wouldn't matter how many rows I insert in between then.
Here is an example of what I have done.
Private Sub CommandButton1_Click()
Range("A900").Select
End Sub
Private Sub CommandButton2_Click()
Range("A3").Select
End Sub
I have many schools, a buttom bring me at the beginning of the school rows then at the end a buttom bring me back up.
Thanks for your help, I'm a beginner.