hide a row

cgriff

Board Regular
Joined
Aug 26, 2002
Messages
201
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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Chris Davison

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,790
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

Active Member
Joined
Aug 15, 2002
Messages
293
Sub Hide()

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

Watch MrExcel Video

Forum statistics

Threads
1,118,328
Messages
5,571,564
Members
412,405
Latest member
DutchMonkey
Top