Row Split not working

  • Thread starter Thread starter Stacy Haskins
  • Start date Start date
S

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 splits 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
 
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
 
Back
Top