Hi,

-If the window is the active one you could use:
With ActiveWindow
.SplitColumn = 0
.SplitRow = 0
End With
-or
knowing the sheet Sh and assuming the window is the first one of the
workbook (you can adapt the code otherwise):
with sh.parent.windows(1) 'window 1 of the book
.SplitColumn = 0
.SplitRow = 0
end with
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Jim Thomlinson" wrote:

Through some sort of an odd excel bug when updaing my pivot table
programmatically (Excel 2000) the window splits. The sheet that is being
updated is never actually selected and if I could I would like to avoid
having to select the sheet. Since split is part of the window object, not the
sheet object how do I remove the split without selecting the sheet? I have
looked at the object model and I am a little baffled as to how I can go about
this...
--
TIA...

Jim Thomlinson