Hi
Is there any changes in VBA codes between 2003 and 2007
I have a problem whit this code.
It works in Excel 2003 but not in Excel 2007
Private Sub CommandButton2_Click()
ActiveSheet.Outline.ShowLevels RowLevels:=1
startline = Range("B1").Value 'startline is defined numers of rows in a colum
endline = Range("c1").Value 'endline is defined numers of rows in a colum
For i = startline To endline
If Range("CC" & i).Value <> 0 Then
Range("b" & i).Activate
Selection.EntireRow.Hidden = False
End If
End Sub
Bookmarks