• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

VBA Excel position rows in split frame

Hi,

Is there any way to reposition the rows/columns in a split frame in Excel from within vba? I want to force a particular row to be at the top of the first pane, and a different row to be at the top of the second pane.

Cheers

bergsy
0
gbergsma
Asked:
gbergsma
1 Solution
 
Saqib Husain, SyedEngineerCommented:
I very strongly feel that this would not be possible. But still you can wait for input from some other expert.

Saqib
0
 
gbergsmaAuthor Commented:
Saqib,

Your "expert" comment was less than useful. Indicating that you strongly feel that it can't be done, particularly when your rank is "Wizard" may put others off from trying to solve the problem.

I have solved the problem myself as below:

    ActiveWindow.Panes(1).ScrollRow = 1
    ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollRow = 4

bergsy
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now