Split and rows.

[sungen99]

I have a spreadsheet that is split vertical in line K. I have a bunch of math from row M to AA and the results at AW and on.

For the user they dont need to see the math so i created a little arrow to click that moves the screen over to AW. only thing is that i need to go further than AW to make it come right against the split. This works just fine for me but on another computer its not right.

Your help please.

[sungen99]

Private Sub CommandButton1_Click()
If CommandButton1.Caption = "Hide Details" Then
Range("L:CO").EntireColumn.Hidden = True
CommandButton1.Caption = "Show Details"
Else
Range("L:CO").EntireColumn.Hidden = False
CommandButton1.Caption = "Hide Details"
End If
End Sub


i did it with vba. works great.......

[Arkadi]

Nice job, was going to suggest hiding the columns...