Window Split and activecell
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
|