Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split in vba
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
split in vba
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
split in vba
On Fri, 07 Mar 2008 14:54:26 -0800, 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 I cannot reproduce your problem. How did you determine that you have this problem? --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
split in vba
I do not have the same problem, what is your code?
-- Regards, Nigel "scott" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
split in vba
I replied to a response to my earlier post and so will fill in here
Using Excel 2003 I positioned a command button around column G or H and call a macro from it, for example. Sub chkCell() Dim test test = ActiveCell.Address MsgBox (test) End Sub I am using the ActiveCell to determine user input and fill in content from other sources at the appropriate row, rather than have thousands of vlookup formulas on the sheet. This works fine when freeze panes is set, but with windows split it determines the ActiveCell as A1. I at first thought it was related to the button location, and perhaps it is related to using the form controls. Any ideas? Thanks scott On Fri, 07 Mar 2008 14:54:26 -0800, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split | Excel Discussion (Misc queries) | |||
How do I remove split a split window? | New Users to Excel | |||
2nd split | Excel Discussion (Misc queries) | |||
Un-Split | Excel Discussion (Misc queries) | |||
split? | Excel Programming |