positioning cells on the screen in excell

RGuillermo
RGuillermo used Ask the Experts™
on
Hello Experts,
i have a set of buttons in my excell sheet, each button is a "goto" to a certain cell.
using: Application.Goto Reference:="R65496C244"

the thing is when going to a particular cell it appears on just about any location in my window...many times in the last row.
or the right most column.

What can I do so all "goto reference"  not only go to the cell but also positions the cell in the second row second column on my excell sheet?

Regards
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Activewindow.scrollrow=activecell.row-1
Activewindow.scrollcolumn=activecell.column-1
RGuillermoProject Manager

Author

Commented:
Excellent !!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial