#1   Report Post  
Member
 
Posts: 57
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Member
 
Posts: 57
Talking

You are brilliant
cheers!!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Specific Cell to Selected Cell W.Easton Excel Worksheet Functions 6 January 12th 07 09:02 PM
Cell References [email protected] Excel Discussion (Misc queries) 2 November 16th 06 12:37 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
how read value from last selected cell? It is possible? how get adress last selected cell? Andrzej New Users to Excel 4 May 30th 05 07:28 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"