Minor tweak to this macro required to get it just right - how to do it?

[cronshd]

Hi

This macro works fine, in that it navigates to the correct cell, however, it leaves 4 rows on the screen above it, whereas I want it 'tight' to the top of the pane.

So it it like this:

R1 Headers
R2 Headers
R3 Bottom of pane
R26 .....stuff
R27 .... stuff
R28 ....stuff
R29 BUY
R30 ......

whereas I want it to be like this

R1 Headers
R2 Headers
R3 Bottom of pane
R29 BUY
R30 .....

Please Login or Register  to view this content.

Thanks for any help.

[HaHoBe]

Hi, cronshd,

the macro does exactly what itīs supposed to do. What you may need to do is delete the rows with blank cells in Column B prior to running the macro or to check and delete empty cells/rows above the cell being activated by the mcaro.

First:

Please Login or Register  to view this content.

Second:

Please Login or Register  to view this content.

Ciao,
Holger

[cronshd]

Hi Holger

Thanks for your reply.

Actually there are no empty rows - they all contain valid data.

It is slightly more complicated than I have shown, because there are 6 sections which can be navigated to with Buttons: BUY, SELL, POS, XDEF, REV, MOR

And the sheet is like this:

R1 Headers
R2 Headers
R3 Bottom of pane
R4 SELL
R5 sell stuff
R6 sell stuff
R7 sell stuff
R8 POS
R9 POS stuff
R10 POS stuff
R11 XDEF
R12 XDEF stuff
......
......
.....
R25 MOR
R26 .....stuff
R27 .... stuff
R28 ....stuff
R29 BUY
R30 ......stuff
R31.....stuff
R32 ....stuff

So - is there a way to do this? It always seems to leave 3 or 4 rows between the Bottom of the Pane and the section naigated to (BUY, SELL, POS, MOR etc....).

Many thanks!

[HaHoBe]

Hi, cronshd,

if you want the cell right at the top of whatīs shown from the worksheet:

Please Login or Register  to view this content.

Ciao,
Holger

[cronshd]

Many thanks Holger - genius! You understood exactly what I needed to do.

It worked first time. I appreciate your time and sharing this, thank you!