Window Split and activecell

  • Thread starter Thread starter scott d
  • Start date Start date
S

scott d

I have ......

Dim Act_Row
Act_Row .= ActiveCell.Row

when a user used Windows Split the activecell seems to be A1
I can't reproduce this on another sheet.
If I have to, should I turn off Windows Split and then return it after
completion in code?
Any idea of how to get arouind this?
I feel like my erro handling is bad on this one.

Thanks
Scott
 
Sorry, this isn't clear.
I actually am trying to determine the starting activecell the user is
in when the code starts.
This works with freeze panes but not a split window
Scott
 
Scott,
Not sure what you are actually after, but you can test the number of Panes
MsgBox ActiveWindow.Panes.Count
MsgBox ActiveWindow.Panes(1).ScrollRow

ActiveCell.Row is correct irrespective of split windows.

NickHK
 
I am not sure what is causing the activecell to be misread.
Nothing fires that I can tell, but if windows split is on it shows A1
as the activecell and freeze panes doesn't have this behavior.
Thanks
scott
 

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

Freeze Panes- Windows Split 2
Split ActiveCell.Value and delete element if......... 6
Activecell and integers 2
Bug - Programmatic copy/paste other sheet to activecell 4
Find value of active cell in other visible worksheets 8
Macro unexpectedly jumps to other macros and functions Options 1
"On Error GoTo" syntax problem 1
Macro to grap certain cells and copy..... 4

Back
Top