I am trying to hide rows based on a value of a sum formula. If the su
fo the row is 0, i want to hide that row. I think this should work
but it is imbedded under other for...next statements. I dont know i
this is a problem, but I get a Next without For error.

Thanks for your help in advance....


For a = 1 To 14
Range("hide").Value = a
Range("hidestart").Offset(a - 1, 0).Select
If cell.Value = 0 Then
Selection.EntireRow.Hidden = True

Next

--
Message posted from http://www.ExcelForum.com