Excel macro: put position of cell in top-left of screen

[Mike]

I have a macro that jumps to a cell in another tab. I would like to position
that cell in the top-left hand of the screen. Right now, it jumps to that
cell but does not do any special positioning. Can anyone help?

Thanks in advance!

 

[Nayab]

I have a macro that jumps to a cell in another tab. I would like to position
that cell in the top-left hand of the screen. Right now, it jumps to that
cell but does not do any special positioning. Can anyone help?

Thanks in advance!

MIke, it will be better to understand ur problem if u can post the
code and detail the problem

 

[Don Guillett]

Easy. Look in the vba help index for GOTO

 

[Mike]

Here is the code (it is very simple):

Sub Definitions_DataManagement()
Application.Goto Reference:="Defntn_DataMgt"
End Sub

This reference is on another Tab of the Excel Workbook. When I run the macro
& jump to that cell, the cell is showing without issue, but it can be
anywhere on the screen (depending on when I last left that tab). I would like
those cells to be in the top left (similar to cell A1 as a sheet is opened).

Thanks!

 

[Mike]

Thank you! This answers it! The "scroll:=True" solves the problem.

 

[Don Guillett]

Glad to help you to help yourself

 

[Kevryl]

Don, I have a very similar question (which I posted yesterday 6th May 2020)
and has disdappeared into the ether).

When I had Office 2000, I tried several times to look up help for VB to find
there wasn't anything on VB in the Help files. Now I've just upgraded to 2007
and of course "Help" so-called is online. I've keyed in "vba help index for
GOTO" and all combinations and permutations including missing off the "A".
All I get is either "no results returned" or references to "forms, form
controls and active x controls".

Sometimes Don, just an extra minute and a few extra words - an example even
- rather than the superior and condescending "help you to help yourself" jibe
could make all the difference to frustration levels and productivity.

Cheers,

 

[Bob I]

Doesn't sound like you are looking in VBA Help, if you haven't enabled
the Developer tab, just press Alt+F11 to open VBA