I can't seem to figure out why this isn't working.
I have a button on two worksheets, which when pressed
puts the page split in the ideal location. One page
works fine, but the same code on the other page will only
split the page vertically. It's like the program is
ignoring the .SplitRow command.

Please email me, , if you have any
solutions or know what could be the cause.

Thanks,
Stacy

Hi
you may post the code behind your button

--
Regards
Frank Kabel
Frankfurt, Germany


Stacy Haskins wrote:
I can't seem to figure out why this isn't working.
I have a button on two worksheets, which when pressed
puts the page split in the ideal location. One page
works fine, but the same code on the other page will only
split the page vertically. It's like the program is
ignoring the .SplitRow command.

Please email me, , if you have any
solutions or know what could be the cause.

Thanks,
Stacy

I finally discovered the solution after all night of
trial and error. Apparently, Excel will not let you use
code to horizontally split a page if row 1 is hidden.
Who knew? Anyhow, in case someone has a similar problem,
I hope this helps.

-Stacy

-----Original Message-----
Hi
you may post the code behind your button

--
Regards
Frank Kabel
Frankfurt, Germany


Stacy Haskins wrote:
I can't seem to figure out why this isn't working.
I have a button on two worksheets, which when pressed
puts the page split in the ideal location. One page
works fine, but the same code on the other page will
only
split the page vertically. It's like the program is
ignoring the .SplitRow command.

Please email me, , if you have
any
solutions or know what could be the cause.

Thanks,
Stacy
.