Moving to another worksheet, specific locaton and scroll
Folks,
In one worksheet I have a command button that takes me to another worksheet. Here's that code:
Once I get to the other worksheet I have another command button that takes me to a specific location. Here's that code:
These codes work. What I would like to do is combine these to the first command button that eliminates the second command button.
In one worksheet I have a command button that takes me to another worksheet. Here's that code:
Private Sub cmdNumericValues_Click()
Worksheets("Text").Activate
End SubOnce I get to the other worksheet I have another command button that takes me to a specific location. Here's that code:
Private Sub cmdNumberFormat_Click()
Range("A47").Select
ActiveWindow.ScrollRow = Range("A47").Row
End SubThese codes work. What I would like to do is combine these to the first command button that eliminates the second command button.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to the both of you. Trying to be fair.
ASKER
I took this from you:
Worksheets("Text").Activat
Range("A47").Select
It failed looking for an object. I then did this
Worksheets("Text").Activat
Worksheets("Text").Range("
leaving the rest of you before and after code as presented and it then worked.
Imnorie - yours worked as presented.
I'd like to share some of the points and thanks to the both of you.