If 2 cells contain hide selection

[Directlinq]

Hi
If cells b4 and b5 both contain certain values at the same time i want to hide rows 7 to 12 but when i click on b4 or b5 the cells unhide.

How can this be done

ive been playing around with this but it wont work properly

show0hide1 = 1 'put 0 to show, put 1 to hide
row2chk = "$38:$47" 'row range to check if G on that row is blank
For rw = Range(row2chk).Cells(1).Row To Range(row2chk).Cells(Range(row2chk).Cells.Count).Row
If Range("B4" & rw).Value <> "29" And Range("G" & rw).Value <> "Single" Then Range("A" & rw).EntireRow.Hidden = show0hide1
Next

[sweep]

Hi,

You need this code to go into the private module of the worksheet object.

On the sheet you want this to happen on, right click the tab, and go to View Code

Paste this code in

Please Login or Register  to view this content.

This checks if the value of B4 and B5 is 8, and if it is hides rows 7:12
When you select B4 or B5, Rows 7:12 are unhidden