View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
scott d scott d is offline
external usenet poster
 
Posts: 5
Default 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