Window Split and activecell
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
On Tue, 30 Jan 2007 10:12:42 +0800, "NickHK"
wrote:
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
"scott d" <please no email wrote in message
.. .
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
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
|