Position selected cell

N

nobbyknownowt

Hi there
This has most likely been answered but I cannot ask the correct search
question to find it.

I have a shared workbook with a long list which has several sections
that apply to different people.
I need to keep the top half of the screen static as it contains the
source data so have frozen the pane at row 19.
I have then created 8 command buttons that are macro linked to move to
the relevant section of the list.
A108, A163 etc etc
This moves the list to the relevant section but positions the start in
the middle of the part of the sheet that is not frozen.
Can I make the macro put the start cell of the relevant section (say
A108) start immediately below the base of the frozen page? (ie A19 then
A108)?

cheers
Nobby
 
D

Dave Peterson

Maybe using a line like:

Application.Goto Range("a108"), scroll:=True

would work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying active cell in particular position on screen 4
Is it possible to "freeze" the cursor position in the middle of apage? 2
Comments box position 0
Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells 2
Positioning the current line at an arbitrary point on the screen 0
Write a letter 3
Using a macro to delete cells from any row 4
Check cell contents before print 3

Top