In all of my testing the activecell address was always correct whether I
split the screen, cascaded screens or used freeze panes... so I really can't
help you. Perhaps let us know which version of XL you are using and post the
code that you have. Normally you don't need the active cell for most things
you program.
--
HTH...

Jim Thomlinson


"scott" wrote:

No one answered previously so i will ask again.

If the window is split rather than freeze panes, in vba the
ActiveCell.Address is misdetected as A1.

Shall I just turn of the user's abiility to split a window in the
workbook? or is there a workaround?

Thanks
Scott