hide a row

[cgriff]

what a am trying to to do is hide a row of data I use =if(a1=456,"")to hide cells how can i hide the row.
thanks in advance

 

[Chris Davison]

On 2002-09-15 05:10, cgriff wrote:
what a am trying to to do is hide a row of data I use =if(a1=456,"")to hide cells how can i hide the row.
thanks in advance

Would the autofilter help ?

apply the autofilter to column A....

then try the following :

is not equal to 456

this will filter out any column A values not equal to 456

 

[seacrest]

Try This
Sub test()
Columns("A:A").ColumnWidth = 0
End Sub

 

[seacrest]

Sorry Row
Rows("4:4").RowHeight = 0

 

[seacrest]

Sub Hide()

If Range("a1")=456 then
Rows("1:1").RowHeight = 0
end if
end sub