|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 31st, 2007, 10:53 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
Position selected cell
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 -- nobbyknownowt 
|
|
#2
January 31st, 2007, 03:49 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Position selected cell
Maybe using a line like:
Application.Goto Range("a108"), scroll:=True would work. nobbyknownowt wrote: 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 -- nobbyknownowt -- Dave Peterson
|
|
#3
February 1st, 2007, 08:00 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Position selected cell
You are brilliant cheers!!! -- nobbyknownowt
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
