Navigate To A Cell and Have It Show At The Top Of Your Screen (Within A Macro)

[miketurn]

Have a few macros that would benefit from this greatly, but don't think I have seen this included.

Is there any macro code that when added, that can allow any macro that navigates your selection cursor (black rectangle) to a specific cell/row that when it navigates it places the result (row / cell) at the top of your screen?

I think I have only seen this be utilized in one macro, which I will find and link below....
This one was different than most though because it was based on removing the ability to double click within a cell to edit, so that may have something to do with it?
@Fluff Response - Number 6
https://www.mrexcel.com/forum/excel-questions/1021609-hyperlink-style-search-macro.html

The macro that I am currently looking for this ability to be used with can be found here...

https://www.mrexcel.com/forum/excel...te-next-cell-bold-text-macro.html#post4928169


Thank You to anyone who reads this and for any help offered.

 

[Rick Rothstein]

Let's say you want to put cell AB123 at the top of the screen...

Range("AB123").Select
ActiveWindow.ScrollRow = ActiveCell.Row

 

[Norie]

You could try Application.Goto.

Application.Goto Range("Z456"), True

 

[miketurn]

@Rick Rothstein / @Norie
Thank you guys for the responses, these both work well but they require you to enter a specific cell location into the macro, but could something like this be done when you do not have a specific cell to navigate to, like say in the case of a "find (search)" like in the example NUMBER 3 of this thread given by @Peter_SSs?
https://www.mrexcel.com/forum/excel...te-next-cell-bold-text-macro.html#post4928169

This macro uses the "find" tool to navigate to the next bold text item, so the cell location really would not be known, is there a way to accomplish this without having to give specific cell info in the macro?

Probably not because I believe the "find" tools navigations are more part of Excels coding and not macro, but I obviously may be incorrect.

 

[Peter_SSs]

I think that I have answered it in that linked thread.

 

[miketurn]

@Peter_SSs

I think that I have answered it in that linked thread.

Indeed you did, thank you for this!