| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window Split and activecell
Sorry, this isn't clear.
I actually am trying to determine the starting activecell the user is in when the code starts. This works with freeze panes but not a split window Scott 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window Split and activecell
Scott,
Not sure what you are actually after, but you can test the number of Panes MsgBox ActiveWindow.Panes.Count MsgBox ActiveWindow.Panes(1).ScrollRow ActiveCell.Row is correct irrespective of split windows. NickHK "scott d" <please no email wrote in message ... Sorry, this isn't clear. I actually am trying to determine the starting activecell the user is in when the code starts. This works with freeze panes but not a split window Scott 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window Split and activecell
I am not sure what is causing the activecell to be misread.
Nothing fires that I can tell, but if windows split is on it shows A1 as the activecell and freeze panes doesn't have this behavior. Thanks scott On Tue, 30 Jan 2007 10:12:42 +0800, "NickHK" wrote: Scott, Not sure what you are actually after, but you can test the number of Panes MsgBox ActiveWindow.Panes.Count MsgBox ActiveWindow.Panes(1).ScrollRow ActiveCell.Row is correct irrespective of split windows. NickHK "scott d" <please no email wrote in message .. . Sorry, this isn't clear. I actually am trying to determine the starting activecell the user is in when the code starts. This works with freeze panes but not a split window Scott 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove split a split window? | New Users to Excel | |||
| split window | New Users to Excel | |||
| double window split? | Excel Discussion (Misc queries) | |||
| Killing the split window | Setting up and Configuration of Excel | |||
| Split Window | Excel Programming | |||
Linear Mode
