Move to specific cell and position window so user can see it.

[twfme57]

I have a worksheet with two sheets. I use macros that goes to specific cells in sheet 2 but when going to cells below where the window can see them, the user can't tell that they've 'arrived' at the correct cell. For instance, when they click the button to go to cell J255 in sheet2, the window isn't in the correct position to show it. Any ideas? Sorry if this has already been asked. TIA!

 

[mumps]

Please post the code you use to go to the specific cells.

 

[twfme57]

Please post the code you use to go to the specific cells.

Sub UGTFMR()
'
' UGTFMR Macro
'

'
Sheets("BF-1").Select
Range("J221").Select
End Sub

Thanks!

 

[FormR]

Hi, you could try like this:

Sub UGTFMR()
Application.Goto Sheets("BF-1").Range("J221"), True
End Sub

 

[twfme57]

Hi, you could try like this:

Sub UGTFMR()
Application.Goto Sheets("BF-1").Range("J221"), True
End Sub

 

[twfme57]

Thanks, but that didn't work.

 

[FormR]

didn't work

Hi, that doesn't really give enough information to allow a follow up suggestion. What happened versus what you would like to happen?

 

[mumps]

Try:

Sub UGTFMR()
    Sheets("BF-1").Select
    Range("J221").Activate
    Application.Goto ActiveCell.EntireRow, True
End Sub

 

[twfme57]

Try:

Sub UGTFMR()
    Sheets("BF-1").Select
    Range("J221").Activate
    Application.Goto ActiveCell.EntireRow, True
End Sub

Hi, that doesn't really give enough information to allow a follow up suggestion. What happened versus what you would like to happen?

Hi, thanks and sorry for the late reply. I'm attaching a couple of screen shots - I have an index page with part categories, the macro for each does jump to the specific category/cell but the screen doesn't scroll down so the user can see it if that makes sense. Thanks again!

 

[mumps]

I tested the code on a dummy workbook and it worked as you requested. It is hard to work with pictures. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).