Row split not working

[Stacy Haskins]

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, (e-mail address removed), if you have any
solutions or know what could be the cause.

Thanks,
Stacy

 

[Frank Kabel]

Hi
you may post the code behind your button

 

[Stacy Haskins]

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