View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott[_12_] scott[_12_] is offline
external usenet poster
 
Posts: 17
Default Freeze Panes- Windows Split

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