Posted to microsoft.public.excel.programming
|
|
Hiding rows
Hi Tom
i missed that one :-)
--
Regards
Frank Kabel
Frankfurt, Germany
Tom Ogilvy wrote:
Why not use the Autofilter under the data menu.
as Frank Said
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
End If
Next a
Cell is undefined, so I believe you mean activeCell
For a = 1 To 14
Range("hide").Value = a
Range("hidestart").Offset(a - 1, 0).Select
If Activecell.Value = 0 Then
Selection.EntireRow.Hidden = True
End If
Next a
"trickdos " wrote in
message
...
I am trying to hide rows based on a value of a sum formula. If the
sum fo the row is 0, i want to hide that row. I think this should
work, 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 a
but it is imbedded under other for...next statements. I dont know
if
this is a problem, but I get a Next without For error.
Thanks for your help in advance....
---
Message posted from http://www.ExcelForum.com/
|