View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott d scott d is offline
external usenet poster
 
Posts: 5
Default Window Split and activecell

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