Hide rows based on formula result in column A

[kwest3904]

Been battling this for a bit now, tried a few others solutions found online to no avail...

I have a spreadsheet in which cells in column A7:A42 have a formula which is 1 if the checkbox in the cell adjacent, i.e. B7:B42, is checked.
The data in cells C7:I42 is populated via VLookup to another tab.
What I am wanting to happen is if rows 38 through 42 are blank for rows 38 through 42 to be hidden.

I tried the below as a test but no go..

Sub HideColumn2()
Dim rCell As Range
Set rCell = Range("A7:A42")

Rows("7:42").EntireRow.Hidden = False
If (Not IsEmpty(rCell))
And (IsNumeric(rCell)
And (rCell.Value = 0) Then
Columns("H").EntireRow.Hidden = True
End If
End Sub

Obviously I am not a VBA expert though have been able to muddle along with multiple others so far. Help is greatly appreciated!

[WideBoyDixon]

Hey there,

Firstly, please use code tags when posting code. There's a # button on the toolbar that lets you do this.

Secondly, your question and code don't make much sense. Are you trying to hide all rows where column A is 0? If so, this should get you through:

Please Login or Register  to view this content.

WBD