Works fine for me whether or not the windows are split. Do you have more
details?


"scott" wrote in message
...
Why does a sheet with Windows Split or Windows Freeze Panes give a
different result for the ActiveCell detected?

I have one user who always uses the window split and it messes things
up. Or how do I get the ActiveCell even if the window is split?

Since I never use this window split, I always forget that is what
someone might do.

Sub chkCell()
Dim test
test = ActiveCell.Address
MsgBox (test)
End Sub


Thanks,
scott