Using VBA to check the value of a cell from another sheet to hide a row in another sheet?

[zyntex]

Hello,

I have a file with three sheets.

Table1, Table2 and Table3.

If the cell "C2" of "Table1" has a value cell "C2" of "Table2" will get it too via the formula "=Table1!C2"
Now I want that if cell "C2" of "Table2" has no value row "6" of "Table3" gets hidden.

I had it working within the same sheet with:

Sub Test()    
If Range("C2").Value = "" Then
Rows(6).Hidden = True
Else
Rows(6).Hidden = False
End If
End Sub

At the moment I have this code however I think I messed up the link between the sheets but can't help:

Sub Test()    
If Worksheets("Table2").Cells("C2").Value = "" Then
Worksheets("Table3").Rows("6").Hidden = True
Else
Worksheets("Table3").Rows("6").Hidden = False
End If
End Sub

Also are there any resources you can recommend to get into Excel VBA and especially stuff like the above?

 

[Fluff]

Glad to help

 

[gallen]

Thank you. I want to use it as macro later on that's why I was writing a function. But your line doesn't work for me.

I see the issue as you've realised.

This should work as a one liner:

[COLOR=#333333]Worksheets("Table3").Rows(6).EntireRow.Hidden = val(Worksheets("Table2").Range("C2").Value )= 0[/COLOR]

Or as Fluff rightly pointed out:

[COLOR=#333333]Worksheets("Table3").Rows(6).EntireRow.Hidden = Worksheets("Table1").Range("C2").Value = ""[/COLOR]