+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    19

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

    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.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,017

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

    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

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    19

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

    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!

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,017

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

    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

  5. #5
    Registered User
    Join Date
    08-16-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    19

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

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1