Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any way to get Freeze Panes to work with Split View? | Excel Discussion (Misc queries) | |||
split panes / freeze and zoom | Excel Discussion (Misc queries) | |||
Set Windows Freeze Panes | Excel Worksheet Functions | |||
Freeze and split panes in Excel 2003 | Excel Worksheet Functions | |||
Freeze/Split Multiple Panes in one Worksheet | Excel Programming |