C cgriff Board Regular Joined Aug 26, 2002 Messages 201 Sep 15, 2002 #1 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
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
C Chris Davison MrExcel MVP Joined Feb 15, 2002 Messages 1,790 Sep 15, 2002 #2 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 Click to expand... 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
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 Click to expand... 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
S seacrest Active Member Joined Aug 15, 2002 Messages 293 Sep 15, 2002 #3 Try This Sub test() Columns("A:A").ColumnWidth = 0 End Sub
S seacrest Active Member Joined Aug 15, 2002 Messages 293 Sep 15, 2002 #4 Sorry Row Rows("4:4").RowHeight = 0
S seacrest Active Member Joined Aug 15, 2002 Messages 293 Sep 15, 2002 #5 Sub Hide() If Range("a1")=456 then Rows("1:1").RowHeight = 0 end if end sub